DataStage Technical Interview Questions

Datastage Technical Interview Questions.

Professionals are invited to share the answers in the comment section.

1. Explain what is the difference between IBM Web Sphere Datastage 7.5 Enterprise Edition  and Standard Ascential?
2. Describe how can you remove duplicates in dataset?
3. Differentiate between Job Control and Job Sequence.
4. Can you tell me what is the max size of Data set stage?
5. How can you measure performance in sort stage?
6. Explain how to develop the SCD using LOOKUP stage?
7. Can you explain  some of the errors you experienced in Datastage.
8. What is the main difference between server job and parallel job in Datastage?
9. Under what circumstances you need Modify Stage?
10. How do you run a job using command line in Datastage?
11. Can you tell what is the alternative way where we can do job control?
12. What is the use of job control in Datastage?
13. What do you mean by APT_CONFIG in Datastage? 
14. Whats is the best approach to do a SCD type2 mapping in parallel job? 
15. Explain how can we improve the performance of the job while handling huge amount of data.
16. How do we create read only jobs in Datastage ?
17. Explain how can you implement routines in Datastage.
18. How do you determine the sequence of jobs to load into data warehouse? 
19. Explain the process of Test jobs in Datastage? 
20. What us the difference between Database data and Data warehouse data? 
21. How do you run a Shell Script within the scope of a Datastage job? 
22. What are the main difference between Datastage and Informatica?
23. Explain about job control language such as (DS_JOBS) in Datastage.
24. What do you mean by Invocation ID? 
25. How do we connect two stages which do not have any common columns between them? 
26. In SAP/R3, how can you declare and pass parameters in parallel job . 
27. Explain in detail what is the difference between Hashfile and Sequential File?

Related Posts