Datastage Interview Question and Answers

11. Define 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.
 
Your Name Your Email-ID
Your Answer
12. How the IPC Stage work?
  If we used the IPC Stage between source and target .One process will handling the communication from sequential file stage to IPC stage, and other will handling communication from IPC stage to ODBC stage. As soon as the Sequential File stage has opened its output link, the IPC stage can start passing data to the ODBC stage.
 
Your Name Your Email-ID
Your Answer
13. What are stage variables?
  An intermediate processing variable that retains value during read and doesn’t pass the value into target column.
 
Your Name Your Email-ID
Your Answer
14. What are the types of Containers?
 
    There are Two types of containers namely
  • Local Container
  • Shared Container
 
Your Name Your Email-ID
Your Answer
15. Where the DataStage stored his repository?
  DataStage stored his repository in IBM Universe Database.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 3 of 15