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 what are the various transformation available?

1028

How to reduce warnings?

945

What is the difference between a primary and secondary actor in use case modeling?

1067

Explain what is partitioning? What are the types of partitioning?

973

Explain meta data?

1039

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

1033

Tell me what is full load & incremental or refresh load?

953

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

1009

How can we determine what records to extract?

1083

What is a staging area? Do we need it? What is the purpose of a staging area?

1000

Explain which are the olap tools available that are supported by oracle?

1011

Explain some of modeling tools available in the market?

969

Explain what are non-additive facts?

1035

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

1003

Explain if a flat file cotains 1000 records how can I get first and last records only?

933

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between a primary and secondary actor in use case modeling?

1067

What is the working process for application.cfm?

1051

Explain what is full load & incremental or refresh load?

993

Explain what are the vaious etl tools in the market?

944

Explain difference between data ware house & data mart?

993

What are different deliverables according to phases?

3407

Explain ddl (data definition language)?

1015

Compare and contrast aggregates & indexes

3779

Explain about core dimension, balanced dimension, and dirty dimension?

1012

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

1978

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

906

Explain why dimenstion tables are denormalized in nature?

920

How many project sources we can create in metadata?

1096

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

1020

Explain why denormalization is promoted in universe designing?

962

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