Datastage Interview Question Pdf

1. Whats 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
2. What are routines?
  Routines are the functions which we develop in BASIC Code for required tasks, which we DS is not fully supported (Complex).
 
Your Name Your Email-ID
Your Answer
3. What is orabulk Stage?
  This Stage is used to Bulk Load the Oracle Target Database.
 
Your Name Your Email-ID
Your Answer
4. What is Container?
  Containers are the reusable set of stages.
Types are: Local Container and Shared Container
Local Container is local to the particular job in which we developed the container.
Shared Container is can be used in any other jobs also.
 
Your Name Your Email-ID
Your Answer
12 Page 1 of 2