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.
 
Your Name Your Email-ID
Your Answer
67. How do you schedule or monitoring the job?
  Using the DataStage Director we can schedule or monitor the job.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 14 of 15