Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

what is the syntax of m_dump command?

3 38808

How to run the graph without GDE?

1 12217

What are the different versions and releases of ABinitio ?

2 9601

What is $mpjret? Where it is used in ab-initio?

4 21238

What is AB_LOCAL expression where do you use it in ab- initio?

Cognizant,

5 31897

What is the latest version that is available in Ab-initio?

TetraSoft,

14 70870

What is meant by Co > Operating system and why it is special for Ab-initio ?

2 19931

How Does MAXCORE works?

CTS,

4 19900

what is meant by fancing in abinitio ?

3 17073

what are kinds of layouts does ab initio supports ?

4 21451

what is the relation between EME , GDE and Co-operating system ?

4 23946

What is a ramp limit?

2 14223

What is the difference between partitioning with key and round robin?

TCS, Wipro,

7 27237

How many parallelisms are in Abinitio?

3 11816

What are Cartesian joins?

3 11371

Un-Answered Questions { Data Warehouse }

What is transformation?

1061

How to differentiate between the active and passive transformations?

1087

how does sas handle missing values in assignment statements? : Sas programming

977

What is the definition of cube in datawarehousing?

939

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2177

What are all types of Batches?

983

What is a merge?

1089

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1961

How we can create indexes after completing the loan process?

1153

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1307

What task is 98% of the required work of a business analyst?

994

what is the difference between informatica6.1 and infomatica7.1

2199

Explain what are the advantages of query studio compared to report studio?

976

What do you mean by worklet?

1025

What are the issues you have faced in your project? How did you overcome those issues?

2298

For More Un-Answered { Data Warehouse } Questions Click Here