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?

976

How to reduce warnings?

902

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

1018

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

905

Explain meta data?

957

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

975

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

896

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

950

How can we determine what records to extract?

1029

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

944

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

944

Explain some of modeling tools available in the market?

900

Explain what are non-additive facts?

965

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

940

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

880

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Can we take backup when the database is opened?

1002

Can we start and stop single session in concurent bstch?

891

What is a Decision Tree Algorithm?

4948

What is the difference between filter and lookup transformation?

1026

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

881

Explain what are slowly changing dimensions?

969

How many types of facts and what are they?

953

Who needs data warehousing?

1003

Explain what is difference between query studio and report studio?

934

What is fact less fact table? Where you have used it in your project?

930

Briefly state different between data ware house & data mart?

998

What is the data type of the surrogate key?

932

What is static and local variable?

979

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

1044

Explain the structure of cold fusion?

993

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