Datastage Interview Questions and Answers for freshers and experienced pdf free download

1.  What is the flow of loading data into fact & dimensional tables?
2.  What is the default cache size? How do you change the cache size if needed?
3.  What are types of Hashed File?
4.  What does a Config File in parallel extender consist of?
5.  What is Modulus and Splitting in Dynamic Hashed File?
6.  What are Stage Variables, Derivations and Constants?
7.  Types of views in Datastage Director?
8.  Types of Parallel Processing?
9.  Orchestrate Vs Datastage Parallel Extender?
10. Importance of Surrogate Key in Data warehousing?
11. How to run a Shell Script within the scope of a Data stage job?
12. How to handle Date conversions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
13.  How do you execute datastage job from command line prompt?
14. Functionality of Link Partitioner and Link Collector?
15. Types of Dimensional Modeling?
16. Differentiate Primary Key and Partition Key?
17. Differentiate Database data and Data warehouse data?
18. Containers Usage and Types?
19. Compare and Contrast ODBC and Plug-In stages?
20. Dimension Modeling types along with their significance
21. What are Ascential Dastastage Products, Connectivity?
22. Explain Data Stage Architecture?
23. What is Meta Data Repository?
24. What is Data Stage Engine?
25. What is Dimensional Modeling?
26. What is Star Schema?
27. What is surrogate Key?
28. Why we need surrogate key?
29.  What is Snowflake schema?
30.  Explain Types of Fact Tables?
31. Explain the Types of Dimension Tables?
32. What are stage variables?
33. What is sequencer?
34. What are Active and Passive stages?
35. What is ODS?
36. What are Macros?
37. What is keyMgtGetNextValue?
38. What are stages?
39. What index is created on Data Warehouse?
40. What is container?