Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

What are snapshots? What are materialized views & where do we use them?

1043

Explain what are data marts?

1120

What are the various tools? Explain name a few?

959

Explain what is data validation strategies for data mart validation after loading process?

1030

Why fact table is in a normal form?

991

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

970

How to load the time dimension?

1010

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

980

Where do we use semi and non additive facts?

992

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

1035

Explain the main differences between star and snowflake schema?

980

Explain me what are data marts?

1048

Explain what is type 2 version dimension?

1007

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

1020

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

1066

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain multivalued dependency?

991

Explain what are the basic needs to join two sources in a source qualifier?

1141

Why null values are mapped as 0 in fact tables?

1004

What is cfapplication tag?

971

What is the difference between constraind base load ordering and target load plan?

1119

What is the advantages data mining over traditional approaches?

967

What are the steps of implementing data warehousing?

1045

Difference between cold fusion 5 and cold fusion mx 6?

995

Explain what are fact, dimension, and measure?

992

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1184

What are steps we have to follow in designing the userfriendly universe?

978

What is partitioning? What are the types of partitioning?

1167

Explain when do we analyze the tables? How do we do it?

1000

Explain dimensional modelling?

984

What is an er diagram?

1049

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