Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What are the key features of chameleon that separates it from other algorithms?

1117

What are the different types of schemas used in data warehousing?

950

What is the function of etl when used in data warehousing?

958

What is the purpose of cluster analysis in data warehousing?

1008

Why is business intelligence (bi) important in data warehousing?

940

What are the different types of fact tables used in data warehousing?

993

What are the different types of scd's used in data warehousing?

1247

What are the different models used in cluster analysis?

958

Why facts table is useful in representing the data?

1004

What is the use of dimensional modeling in data warehousing?

983

What is the function of surrogate key in data warehousing?

1064

Why is chameleon method used in data warehouse?

1165

Why is dimensional normalization not required?

1088

What are the different ways to represent the loading of dimension tables?

935

What is the difference between data warehouse and operational systems?

1141

Un-Answered Questions { Data Warehouse }

What should I have in mind when building olap solution from scratch?

983

What is difference between primary key and unique key constraints?

989

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2117

What is xml source qualifier transformation in informatica?

1217

draw informatica architecture 8.6 ?

3871

Mention the difference between ‘macros’ and ‘prompt’?

1147

What is decode in static cache?

1178

Explain standard filters?

1003

Explain the versions of reportnet?

987

What information is provided by .dbc file extension for connecting to the database?

1170

What are the approaches used by optimizer during execution plan?

904

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1152

what is repositery?

1843

What is a implicit attribute in microstrategy?

1657

Have you used macros? For what purpose you have used? : sas-macro

1041

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