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

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 4848

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13304

what is mystery dimension?

1 5902

what are cost based and rule based approaches and what is the difference?

1 5463

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 8047

what is the difference between stop and abort?

TCS,

3 16569

What is Micro Strategy? Why is it used for?

Infosys,

5 25491

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9434

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 7140

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 5406

what are the real time problems generally come up while doing or running mapping or any transformation?

2 7046

Explain one complecated mapping?

Fidelity, Wipro,

3 15106

Explain the flow of data in Iinformatica?

1 9830

What does dependency analysis mean in Ab Initio?

Syntel,

5 29530

How to Create Surrogate Key using Ab Initio?

IBM,

6 32681

Un-Answered Questions { Data Warehouse }

explain html document?

1008

What is the SAS data set?

1130

What are all types of Batches?

1029

what is Forward,Reverse and Re_engineering?

2250

where are dashboard components are created and maintained? : Sas-bi

1013

What is Discover and Execute in XMLA?

2409

What is the function of look up transformation?

1123

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

2276

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1777

Why do we use exception activity in Datastage?

1314

Explain the difference between rolap and molap?

981

What do you know about abinitio?

1259

Which command is used to save logs in the external file?

1099

What is cognos reporting tool?

1089

What is standalone command task?

1315

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