Datastage Interview Questions and Answers
Data Warehousing
Follow Us
TAGS
11. | What is the difference between DataStage and Informatica? |
---|---|
|
12. | What is data aggregation? |
---|---|
An operational data source usually contains records of individual transactions such as product sales. If the user of a data warehouse only needs a summed total, you can reduce records to a more manageable number by aggregating the data. |
13. | What are the types of server components? |
---|---|
|
14. | What is datastage job? |
---|---|
DataStage jobs consist of individual stages. Each stage describes a particular database or process. For example, one stage may extract data from a data source, while another transforms it. Stages are added to a job and linked together using the designer. |
15. | What are the types of stage? |
---|---|
A stage can be passive or active. A passive stage handles access to databases for
the extraction or writing of data. Active stages model the flow of data and provide
mechanisms for combining data streams, aggregating data, and converting data
from one data type to another. There are two types of stage : Built in stages : Supplied with DataStage and used for extracting, aggregating, transforming, or writing data. Plug in stages : Additional stages defined in the DataStage Manager to perform tasks that the built-in stages do not support. |