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 10440

how you create security to cubes ?????

iFlex, iGate,

4 9475

how u create security to reports ????

iFlex, iGate,

10 19131

fiscal year means what???

iFlex, iGate,

8 16344

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 22810

Explain about HLD and LLD ?

Accenture,

16 149308

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

Accenture,

9 27688

explain different types of modeling.

2 11398

what is the syntax for aggregate awareness?

Exilant, i-Tree, Wipro,

3 20130

Draw the architecture of traps?

Wipro,

3 8893

how do u migrate BO 6.x to XI ?

Cognizant, HCL, IBM, Wipro,

52 53940

what is confirm dimension ?

IBM, Wipro,

11 36633

how do u resolve contexts ?

Wipro,

6 10702

what are slowly changing dimensions, confirm dimensions?

Wipro,

1 8772

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

4 21387

Un-Answered Questions { Data Warehouse }

Do we need an etl tool?

1036

Can any one explain the hierarchies level data warehousing.

1005

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2251

what is Forward,Reverse and Re_engineering?

2266

What is teradata?

1174

What is factor analysis?

1149

How to clean the datastage repository?

1136

what are the devoleper roles in real time? plz tell i am new to datastage....

2173

What are the differences between star and snowflake schema?

1122

What are the different types of metrics available in microstrategy?

989

What is oci?

1322

Why managing the data is important?

1026

How to create or import flat file definition in to the warehouse designer?

1081

Why cognos decision stream is used?

1179

In warehouses how many schemas are there?

1089

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