Datastage Interview Question and Answers

21. What are Routines?
  Routines are the functions which we develop in BASIC Code for required tasks, which we Datastage is not fully supported (Complex).
 
Your Name Your Email-ID
Your Answer
22. What are the Job parameters?
  These Parameters are used to provide Administrative access and change run time values of the job.EDIT > JOBPARAMETERSIn that Parameters Tab we can define the name,prompt,type,value.
 
Your Name Your Email-ID
Your Answer
23. What is the difference between Hashfile and Sequential File?
  Hash file stores the data based on hash algorithm and on a key value. A sequential file is just a file with no key column. Hash file used as a reference for look up. Sequential file cannot.
 
Your Name Your Email-ID
Your Answer
24. What is the use of datastage designer?
  A design interface used to create DataStage applications(known as jobs). Each job specifies the data sources, the transforms required, and the destination of the data. Jobs are compiled to create executables that are scheduled by the Director and run by the Server.
 
Your Name Your Email-ID
Your Answer
25. Explain Datastage architecture?
 
    Datastage contains two components :
    Client Components :
  • Datastage Designer
  • Datastage Director
  • Datastage Manager
  • Datastage Administrator
    • Server components :
  • Repository
  • Datastage Server
  • Datastage Package Installer
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 5 of 15