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

Can we take backup when the database is opened?

1044

What are the types of dimensional modeling?

1063

What are the steps to build the datawarehouse?

1040

What is execution plan?

1201

What needs to be done when the database is shutdown?

1026

Whether dimension table can have numeric value?

1148

What are the steps involved in creating dimensional modeling process?

1021

What is the difference between agglomerative and divisive hierarchical clustering?

1185

What are the key features of chameleon that separates it from other algorithms?

1117

What are the different types of schemas used in data warehousing?

950

What is the function of etl when used in data warehousing?

958

What is the purpose of cluster analysis in data warehousing?

1008

Why is business intelligence (bi) important in data warehousing?

943

What are the different types of fact tables used in data warehousing?

993

What are the different types of scd's used in data warehousing?

1247

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are non-additive facts in detail?

995

What are the design methods of data warehousing?

950

Compare cold fusion with other programming languages?

1007

What is batch processing?

1031

Explain why fact table is in normal form?

970

How to generate iqd file from framework manager?

961

Why facts table is useful in representing the data?

1005

Explain dimension table ?

983

How did you plan your Data ware house project?

2306

What we will do with the universe for faster process?

982

Whether dimension table can have numeric value?

1148

Explain why are oltp database designs not generally a good idea for a data warehouse?

1030

Code the tables statement for a single-level (most common) frequency?

931

What are various warehousing tools?

1004

What is Cognos script editor?

2555

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