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?

911

Explain where do we use semi and non additive facts?

959

What is cost benefit analysis (cba)?

938

Explain what is the data type of the surrogate key?

917

Explain what is the difference between olap and datawarehosue?

1032

What are modeling tools available in the market?

924

Explain what is the advantages data mining over traditional approaches?

973

What is your spectra photometer working principles?

933

What we will do with the universe for faster process?

922

What are the various file formats involved in reportnet?

911

Explain how many ways you create ports?

963

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

919

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

932

Explain what are components of reportnet?

903

Explain a relation schema and a relation?

1036

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is informatica architecture?

1009

What is Discover and Execute in XMLA?

2345

What needs to be done while starting the database?

1049

How can we run the graph?

995

Explain grouped cross tab?

2568

What are the data marts?

917

What are the types of SCD?

1092

What is cost benefit analysis (cba)?

938

Is there any difference in testing database and data ware housing?

2694

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

1015

What are session timeout and application timeout? Where we have to do this process?

978

What is the difference between olap and datawarehosue?

897

Suggest a good author for hyperion in data warehousing?

885

What are the different types of data warehouses?

1016

Explain me what are data marts?

1004

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