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

Why fact table is in a normal form?

999

Explain the main difference between inmon and kimball philosophies of data warehousing?

979

How to load the time dimension?

1024

What are the advantages of raid 1, 1/0, and

982

Where do we use semi and non additive facts?

999

In microstrategy, how can we direct the sql generated to use a specifc table?

1044

Explain the main differences between star and snowflake schema?

996

Explain me what are data marts?

1060

Explain what is type 2 version dimension?

1017

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1029

Explain what is the difference between a primary and secondary actor in use case modeling?

1086

How are the dimension tables designed?

1011

What is cubes?

1078

What is analytical or analytic mean?

1136

What are non-additive facts in detail?

1006

Un-Answered Questions { Data Warehouse }

How can you clear the cache?

1021

How to read multiple files using a single datastage job if files have the same metadata?

1258

what is the main role of FI on business

2116

What do you understand by local lookup?

1170

Is stop and abort are same in informatica?

1013

Explain the term 'tables' related to relational database management system?

1064

Define olap designer?

1141

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1911

Explain how many universes can be created in a project?

1074

what is the difference between cardinality and Nullability?

2956

Explain Dataware house architecture .how data flow from intial to end?

2594

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2058

what is xcelsius architecture?

4602

How can we run the graph? How can we schedule the graph in unix?

963

Explain what are the measure objects?

1003

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