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?

964

Explain where do we use semi and non additive facts?

1018

What is cost benefit analysis (cba)?

994

Explain what is the data type of the surrogate key?

976

Explain what is the difference between olap and datawarehosue?

1090

What are modeling tools available in the market?

977

Explain what is the advantages data mining over traditional approaches?

1027

What is your spectra photometer working principles?

982

What we will do with the universe for faster process?

982

What are the various file formats involved in reportnet?

976

Explain how many ways you create ports?

1023

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

966

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

976

Explain what are components of reportnet?

973

Explain a relation schema and a relation?

1109

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are components of report studio?

1053

What is the difference between power center and power mart?

1021

What is a source qualifier?

1103

What are the data types present in bo? What happens if we implement view in the designer n report?

934

Explain what are the advantages and disadvantages of reporting directly against the database?

1002

What is the difference between constraind base load ordering and target load plan?

1119

what are different storage options supported by oracle ?

2090

What are modeling tools available in the market?

977

Explain what are the steps to build the data warehouse?

951

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

961

How to limit the max no of rows retrieved in the report?

984

Can decision tree be implemented using SQL?

2125

What is difference between query studio and report studio?

1088

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1224

Do you view contain data?

934

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