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?

1042

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?

1029

Why fact table is in a normal form?

990

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

969

How to load the time dimension?

1008

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

980

Where do we use semi and non additive facts?

991

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

1035

Explain the main differences between star and snowflake schema?

979

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?

1019

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

1065

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is operational data store (ods)?

1016

What are the steps involved in creating dimensional modeling process?

1021

How to generate the cubes in framework manager?

1040

What are the different types of data warehouses?

1084

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1985

Can you brief about the Data warehouse project you worked on?

2377

Explain the different types of data warehousing?

990

What is the difference between dependent data warehouse and independent data warehouse?

1007

Why is chameleon method used in data warehouse?

1165

What is a functional dependency f said to be minimal?

1063

What are the types of partitioning?

1049

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2242

What is a view as it relates to system modeling?

979

Explain the difference between dw and bi?

1047

Can any one explain the hierarchies level data warehousing.

992

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