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 are the applications of the tabular model ????

iFlex, iGate,

5 10447

how you create security to cubes ?????

iFlex, iGate,

4 9477

how u create security to reports ????

iFlex, iGate,

10 19144

fiscal year means what???

iFlex, iGate,

8 16353

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

Accenture,

11 22812

Explain about HLD and LLD ?

Accenture,

16 149323

how u know when to use a static cache and dynamic cache in lookup transformation.

Accenture,

9 27693

explain different types of modeling.

2 11400

what is the syntax for aggregate awareness?

Exilant, i-Tree, Wipro,

3 20134

Draw the architecture of traps?

Wipro,

3 8895

how do u migrate BO 6.x to XI ?

Cognizant, HCL, IBM, Wipro,

52 53946

what is confirm dimension ?

IBM, Wipro,

11 36634

how do u resolve contexts ?

Wipro,

6 10707

what are slowly changing dimensions, confirm dimensions?

Wipro,

1 8777

what is shared Cache. when we will use shared Cache?

4 21390

Un-Answered Questions { Data Warehouse }

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4125

Can you explain new content durability?

1045

What is the scenario which compels informatica server to reject files?

1088

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1394

How many number of sessions can one group in batches?

1184

What are objects? Name different type of objects in microstrategy?

949

what is Forward,Reverse and Re_engineering?

2215

how to load rows into fact table in data warehouse

1206

Describe the evaluation of parameters order in ab initio?

1543

What is the max core of a component?

1116

for whom is sas data integration studio designed? : Sas-di

1018

How to start a workflow using pmcmd command?

1261

Explain oject manager?

1016

What is ibm datastage?

984

What is application.cfm?

1059

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