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

What is iconv and oconv functions?

What is project life cycle and how do you implement it?

For what purpose is the Stage Variable is mainly used?

Explain the purpose of using the key and difference between Surrogate keys and natural key

How to read the data from XL FILES?my problem is my data file having some commas in data,but we are using delimitor is| ?how to read the data ,explain with

steps?

How can I schedule the cleaning of the file &PH& by dsjob?

What are Hot Fix for ODBC Stage for AS400 V5R4 in Datastage 7.1

What is Datastage engine?what is its purpose?

What is the difference between Transform and Routine in Datastage?

Why is hash file is faster than sequential file n odbc stage?

How to write and execute routines for PX jobs in c++?

What is a routine?

How to distinguish the surrogate key in different dimentional tables?

How can we generate a surrogate key in server/parallel jobs?

What is NLS in Datastage? how we use NLS in Datastage ?

How did you handle reject data?

What is difference between ETL and ELT?

How to read the data from XL FILES?explain with steps?

What is the meaning of performance tuning techinque,Example?

Differentiate between pipeline and partion parallelism?

What is the use of Hash file?Instead of hash file why can we use sequential file itself?

What is pivot stage?why are you using?what purpose that stage will be used?

How can we create environment variables in Datastage?

What is the difference between static hash files n dynamic hash files?

How can we test the jobs?

What is the difference between reference link and straight link ?

What are the command line functions that import and export the DS jobs?

What is the size of the flat file?

What is the difference between operational Datastage (ODS) & data warehouse?

What are the various process which starts when the Datastage engine starts?

What are the changes need to be done on the database side, If I have to use dB2 stage?

Datastage engine is responsible for compilation or execution or both?

How to use rank updates strategy in Datastage

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

What is Runtime Column Propagation and how to use it?

How we use the Datastage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the

resulting executable versions on ad hoc or scheduled basis?

What is the difference between OCI stage and ODBC stage?

Is there any difference b/n Ascential Datastage and Datastage .

How do you remove duplicates without using remove duplicate stage?

If a Datastage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?

How to remove duplicates in server job

What is the exact difference betwwen Join,Merge and Lookup Stage?

What are the new features of Datastage 7.1 from Datastage 6.1

How to run the job in command prompt in unix?

How to know the no.of records in a sequential file before running a server job?