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

Explain snowflake schema?

1034

what do you mean by custom groups?

983

what do you mean by kimball?

1001

Explain the difference between holap and molap?

1052

Explain fact relation?

1011

Explain security filter?

1022

How do you optimize reports in microstartegy?

1109

Explain transformations?

1007

How would you configure wh authentication? Explain.

997

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

930

Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.

1021

Is there a difference between view filter and report filter?

920

Explain compound key?

981

Explain standard filters?

1003

Explain two-tier connection?

942

Un-Answered Questions { Data Warehouse }

Explain fact relation?

1011

Explain about round-robi?

1146

Compare cold fusion with other programming languages?

1006

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2194

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2056

What are the different types of reports present in cognos?

984

What is the difference between power center & power mart?

981

What if the source is a flat-file?

1110

What are the available join types in teradata?

1066

Define enterprise data warehousing?

1204

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

951

What are the joins in teradata?

1009

what is snowflake schema? : Sas-di

1215

How do you ensure simultaneous releases across multiple operating systems?

970

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