Data Stage

What versions of DS you worked with?
Ans: DS 7.0.2/6.0/5.2

What is the importance of Surrogate Key in Data warehousing?

How can you do incremental load in Datastage? How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? Explain briefly? What is APT_CONFIG in Datastage How do we do the automation of dsjobs?

What is merge and how it can be done Please explain with simple example taking 2 tables?
Is it possible to run parallel jobs in server jobs?

How to drop the index before loading data in target and how to rebuild it in Datastage?
How can ETL excel file to Datamart?

Overview:Data Warehousing Interview Questions,DataStage Interview Questions asked in HCL,Wipro,TCS,Infosys,Tech Mahindra,Patni,Sasken,Birlasoft

Data Warehouse Interview Questions,Live DataStage Tool Interview Questions.
What are Static Hash files and Dynamic Hash files?

How do we create index in Datasatge?
What is the flow of loading data into fact & dimensional tables?
What is a sequential file that has single input link?

What is the difference between IBM Web Sphere Datastage 7.5 (Enterprise Edition ) & Standard Ascential?
How do you remove duplicates in dataset

What are the Environmental variables in Datastage?
How do you check for Job Errors in Datastage
What are Stage Variables, Derivations and Constants?