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 6743

What is staging area?

9 17349

What is data merging, data cleansing and sampling?

1 7730

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

2 5229

OLAP architecture?

CTS, Honeywell,

1 6038

What is subject area?

2 10624

Why do we use DSS database for OLAP tools?

3 10638

What is ?Data Warehousing??

Accenture,

3 6608

What are Data Marts?

2 5829

What are Fact tables and Dimension Tables?

IBM,

6 57372

What is Snow Flake Schema design in database?

3 8015

What is ETL process in Data warehousing?

3 17064

How can we do ETL process in SQL Server?

ETL,

1 7010

What is ?Data mining??

2 5470

Compare ?Data mining? and ?Data Warehousing??

5 10916

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are non-additive facts in detail?

995

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1971

Explain what are the modules in power mart?

1051

Explain when do we analyze the tables? How do we do it?

999

How to test report in reportnet?

1010

What are algorithms provided by Microsoft in SQL Server?

2052

Explain what is full load & incremental or refresh load?

984

What is the limit to the number of sources and targets you can have in a mapping?

1108

What are the advantages and disadvantages of reporting directly against the database?

982

Describe the differences between a data warehouse and data mart.

1000

Explain what is the difference between power center & power mart?

999

What are the steps to build the datawarehouse?

1038

Explain what is the limit to the number of sources and targets you can have in a mapping?

1003

What is data validation strategies for data mart v?

1090

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

958

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