Datastage Interview Question and Answers

16. What is Staging Variable?
  These are the temporary variables created in transformer for calculation.
 
Your Name Your Email-ID
Your Answer
17. How do you generate Sequence number in Datastage?
 
    Using the Routine
  • KeyMgtGetNextVal
  • KeyMgtGetNextValConn
  • They can also be done by Oracle Sequence.
 
Your Name Your Email-ID
Your Answer
18. What is the difference between Server Job and Parallel Jobs?
  Server Jobs works in sequential way while parallel jobs work in parallel fashion (Parallel Extender work on the principal of pipeline and partition) for Inpur/Output processing.
 
Your Name Your Email-ID
Your Answer
19. What is the difference between Account and Directory options ?
  Account option create the hashfile in the current project itself using condition and for Directory option we have to specify the path of the directory.
 
Your Name Your Email-ID
Your Answer
20. What are the types of jobs we have in Datastage?
 
  • Server Jobs
  • Parallel Jobs
  • Mainframe Jobs
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 4 of 15