Datastage Interview Question and Answers

71. What is merge stage?
  The Merge stage combines a sorted master data set with one or more sorted update data sets. The columns from the records in the master and update data sets are merged so that the output record contains all the columns from the master record plus any additional columns from each update record.
 
Your Name Your Email-ID
Your Answer
72. What is the difference between datastage manager and datastage administrator?
  DataStage Manager : A user interface used to view and edit the contents of the Repository.
DataStage Administrator : A user interface used to set up DataStage users, create and move projects, and set up purging criteria.
 
Your Name Your Email-ID
Your Answer
73. How we can reuse the components?
  Using the Shared and Local Containers.
 
Your Name Your Email-ID
Your Answer
74. What can we do with DataStage Director?
 
  • Validating
  • Scheduling
  • Executing and Monitoring Jobs (server Jobs)
 
Your Name Your Email-ID
Your Answer
75. What are the Types of Jobs?
 
  • Server Jobs : Designed, developed and compiled are done in Designer. Validated, Scheduled, Executed and Monitoring are done in Director. Win NT/ Unix system Server.
  • Parallel Jobs : Designed, developed and compiled are done in Designer Validated, Scheduled, Executed and Monitoring are done in Director. Server should be on Unix System Only.
  • Mainframe Jobs : Designed and developed are done in Designer (win) Complied, Validated, Scheduled, Executed and Monitored in Mainframe Systems Only.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 15 of 15