Datastage Interview Question and Answers
| 66. |
What is transformer stage? |
| |
Transformer stages do not extract data or write data to a target database. They are used to handle extracted data, perform any conversions required, and pass data to another Transformer stage or a stage that writes data to a target data table. |
| |
|
| 67. |
How do you schedule or monitoring the job? |
| |
Using the DataStage Director we can schedule or monitor the job.
|
| |
|
| 68. |
Define universe stage? |
| |
A stage that extracts data from or loads data into a Universe database using SQL. Used to represent a
data source, an aggregation step, or a target data table.
|
| |
|
| 69. |
What are the types of stages? |
| |
- 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.
|
| |
|
| 70. |
What are the advantages of data warehousing? |
| |
A data warehousing strategy provides the following advantages :- Capitalizes on the potential value of the organization’s information.
- Improves the quality and accessibility of data.
- Combines valuable archive data with the latest data in operational sources.
- Increases the amount of information available to users.
- Reduces the requirement of users to access operational data.
- Reduces the strain on IT departments, as they can produce one database to serve all user groups.
- Allows new reports and studies to be introduced without disrupting operational systems.
- Promotes users to be self sufficient.
|
| |
|
Gk Questions with Answers