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?

967

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?

977

Explain what is the difference between olap and datawarehosue?

1092

What are modeling tools available in the market?

978

Explain what is the advantages data mining over traditional approaches?

1029

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?

982

Explain how many ways you create ports?

1024

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

975

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

976

Explain what are components of reportnet?

975

Explain a relation schema and a relation?

1111

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Difference between cold fusion 5 and cold fusion mx 6?

996

Explain what is the difference between stop and abort?

1045

Explain the definition of normalized and denormalized view?

903

What is the difference between ods and oltp?

1021

Explain what are the basic needs to join two sources in a source qualifier?

1141

What are the different methods of loading dimension tables?

995

Explain ddl (data definition language)?

1007

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1973

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1104

Why we use repository connectivity?

981

Explain dimensional modelling?

985

What are diagrams?

1042

What is data mart in data warehouse?

953

In document how to create metrics?

992

What is data warehosuing hierarchy?

1172

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