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 6801

What is staging area?

9 17606

What is data merging, data cleansing and sampling?

1 7824

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

2 5348

OLAP architecture?

CTS, Honeywell,

1 6121

What is subject area?

2 10769

Why do we use DSS database for OLAP tools?

3 10747

What is ?Data Warehousing??

Accenture,

3 6736

What are Data Marts?

2 5938

What are Fact tables and Dimension Tables?

IBM,

6 57583

What is Snow Flake Schema design in database?

3 8137

What is ETL process in Data warehousing?

3 17178

How can we do ETL process in SQL Server?

ETL,

1 7094

What is ?Data mining??

2 5559

Compare ?Data mining? and ?Data Warehousing??

5 11118

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is full load & incremental or refresh load?

1032

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

1017

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2296

Name a few sectors which use data warehousing?

984

What are the various file formats involved in reportnet?

1026

How to provide security in frame work manager for a query subject?

1010

What is recovering sessions?

997

Explain about core dimension,

1036

What is a full backup?

1017

What is edw?

1269

Explain what are the modules in power mart?

1094

What is data type of the surrogate key?

1054

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1165

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

1047

What is a linked cube?

1047

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