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

Explain me what are conformed dimensions?

1096

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

1020

What is fact less fact table? Where you have used it in your project?

1079

What is pre-emptive and non-pre-emptive?

1028

Explain what does level of granularity of a fact table signify?

1000

What is ods (operation data source)?

1060

What is data validation strategies for data mart v?

1172

Explain what are fact, dimension, and measure?

1045

Explain why denormalization is promoted in universe designing?

1000

What is latest version of power center / power mart?

1143

What is partitioning? What are the types of partitioning?

1231

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

971

What is an er diagram?

1101

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

966

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1075

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is VLDB?

1112

What are the fundamental elements of the data warehouse?

1052

What is is a star schema?

1258

What is an error log table in informatica occurs and how to maintain it in mapping?

1006

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

1016

How to test report in reportnet?

1054

Explain what is the difference between datawarehouse and bi?

1019

How to create context?

1062

What are the methodologies of data warehousing?

1035

Why facts table is useful in representing the data?

1048

Explain what is the extension of file to save template?

1018

What is normalization, first normal form, second normal form, third normal form?

1019

What are universe requirements?

1116

How many project sources we can create in metadata?

1161

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

1010

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