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 is difference between a connected look up and unconnected look up?

1 6745

What is staging area?

9 17381

What is data merging, data cleansing and sampling?

1 7741

What is up date strategy and what are th options for update strategy?

2 5240

OLAP architecture?

CTS, Honeywell,

1 6053

What is subject area?

2 10639

Why do we use DSS database for OLAP tools?

3 10654

What is ?Data Warehousing??

Accenture,

3 6626

What are Data Marts?

2 5857

What are Fact tables and Dimension Tables?

IBM,

6 57390

What is Snow Flake Schema design in database?

3 8026

What is ETL process in Data warehousing?

3 17081

How can we do ETL process in SQL Server?

ETL,

1 7022

What is ?Data mining??

2 5478

Compare ?Data mining? and ?Data Warehousing??

5 10940

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain is olap databases are called decision support system true/false?

1009

What is an er diagram?

1054

What are partition points?

1080

What is mean by aggregate aware?

1095

How can we run the graph?

1075

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

980

Explain what is difference between query studio and report studio?

994

Difference between PowerPlay transformer and power play reports?

2523

What is Analysis Services?

2149

What is a Decision Tree Algorithm?

5012

What according to you might be the future of data warehousing?

1029

What is the difference between connected and unconnected stored procedures?

1087

What are aggregate tables and aggregate fact tables?

1041

Explain the definition of normalized and denormalized view and what are the differences between them?

931

What are the various methods of getting incremental records or delta records from the source systems?

938

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