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 normalization, first normal form, second normal form, third normal form?

1020

Explain where do we use semi and non additive facts?

1063

What is cost benefit analysis (cba)?

1045

Explain what is the data type of the surrogate key?

1029

Explain what is the difference between olap and datawarehosue?

1142

What are modeling tools available in the market?

1022

Explain what is the advantages data mining over traditional approaches?

1074

What is your spectra photometer working principles?

1035

What we will do with the universe for faster process?

1028

What are the various file formats involved in reportnet?

1026

Explain how many ways you create ports?

1077

Explain how to get the first 100 rows from the flat file into the target?

1026

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

1048

Explain what are components of reportnet?

1025

Explain a relation schema and a relation?

1168

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is full load & incremental or refresh load?

1032

Compare and contrast aggregates & indexes

3820

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

1151

what are the all possible features supported modify stage?

2224

Explain what is the difference between stop and abort?

1092

Explain how are the dimension tables designed?

1108

What is Sequence clustering algorithm?

2071

What is the difference between static cache and dynamic cache?

1060

Why should we use data ware housing and how can you extract data for analysis with example?

1044

How can you clear the cache?

1057

What is load manager?

1108

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

What is factless fact tables?

1286

What is surrogate key? Where we use it?

1040

What is execution plan?

1257

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