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?

1098

Explain what are data marts?

1201

What are the various tools? Explain name a few?

1022

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

1078

Why fact table is in a normal form?

1028

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

1017

How to load the time dimension?

1057

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

1022

Where do we use semi and non additive facts?

1039

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

1091

Explain the main differences between star and snowflake schema?

1042

Explain me what are data marts?

1106

Explain what is type 2 version dimension?

1070

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

1089

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

1120

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is core dimension?

1123

What is data validation strategies for data mart v?

1172

What is the use of dimensional modeling in data warehousing?

1048

What is the extension of file to save template?

1054

Explain how to get the first 100 rows from the flat file into the target?

1027

How can you communicate with web server (apache or iis) from coldfusion?

1190

What is the difference between Datawarehouse and OLAP?

973

Explain which columns go to the fact table and which columns go the dimension table?

968

What is prompt types of prompts?use of prompts syntax of prompt?

1431

Explain which are the olap tools available that are supported by oracle?

1049

Explain meta data?

1109

Ist the schema that a data warehouse system can implements.

993

Who needs data warehousing?

1127

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

1013

What is vldb(very large databases)?

1073

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