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 type of raid setup would you put your tx logs?

952

What is a general purpose scheduling tool?

1117

What is the metadata extension?

1004

What a static and local variable?

1083

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

1003

Explain what are the different methods of loading dimension tables?

957

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

966

Explain what is full load & incremental or refresh load?

992

Explain what is the metadata extension?

1043

What are the main steps to build the data warehouse?

1121

Explain what is the difference between datawarehouse and bi?

974

What is scd1 , scd2 , scd3?

1092

Explain the difference between oltp and olap?

1129

What is a data warehousing?

1158

What is a fact table?

1 1637

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the steps to build the datawarehouse?

1040

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

931

Can you pass sql queries in filter transformation?

1023

What is a full backup?

973

What is the difference between view filter and report filter?

930

What are components of report studio?

1057

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1389

Explain er diagram?

999

How much data hold in one universe.

995

What is the purpose of cluster analysis in data warehousing?

1012

Which are the olap tools available that are supported by oracle?

937

What is degenerate dimension table?

1005

Can decision tree be implemented using SQL?

2132

What is the difference between ods and oltp?

1028

Explain what are non-additive facts?

1035

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