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?

965

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?

1090

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?

977

Explain how many ways you create ports?

1024

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

970

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?

1109

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is data analysis?

958

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1004

How to generate the cubes in framework manager?

1041

Explain dimensional modelling?

984

Explain conformed fact?

965

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

1106

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

1044

Why fact table is in a normal form?

991

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

904

What is the difference between power center & power mart?

981

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2271

Explain what are conformed dimensions?

1089

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2341

Is union transormation is active transformation?

975

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

897

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