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?

995

What is a general purpose scheduling tool?

1175

What is the metadata extension?

1067

What a static and local variable?

1134

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

1046

Explain what are the different methods of loading dimension tables?

995

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?

1008

Explain what is full load & incremental or refresh load?

1032

Explain what is the metadata extension?

1098

What are the main steps to build the data warehouse?

1163

Explain what is the difference between datawarehouse and bi?

1019

What is scd1 , scd2 , scd3?

1138

Explain the difference between oltp and olap?

1175

What is a data warehousing?

1226

What is a fact table?

1 1726

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

1064

What is the difference between junk dimension and degenerated dimension?

1237

What is the difference between agglomerative and divisive hierarchical clustering?

1245

What is the difference between star and snowflake schemas?

1317

What is bi?

1180

How to test report in reportnet?

1054

Explain why fact table is in normal form?

1017

Explain why dimenstion tables are denormalized in nature?

973

Explain a mapping, session, worklet, workflow, mapplet?

1151

explain about balanced dimension,

1033

Explain why should you put your data warehouse on a different system than your oltp system?

988

in general which algorithms for used?

2073

How much data hold in one universe.

1034

What are non-additive facts in detail?

1054

What is edw?

1269

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