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?

960

What is the purpose of cluster analysis in data warehousing?

1008

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

943

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

994

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

1247

What are the different models used in cluster analysis?

960

Why facts table is useful in representing the data?

1005

What is the use of dimensional modeling in data warehousing?

986

What is the function of surrogate key in data warehousing?

1065

Why is chameleon method used in data warehouse?

1166

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 is called materialized view?

1076

How would you increase the logical size of a table in microstrategy?

971

Explain in detail about scd type 1 through mapping.

1555

What are the different types of important services used in cognos?

1018

Difference between PowerPlay transformer and power play reports?

2517

You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?

870

Differentiate between validated and Compiled in the Datastage?

1282

Parameter and variable differences

2062

Your application mode has crashed. How would you get the instance back?

936

What is decode in static cache?

1179

Where is teradata rdbms used?

1097

What is catalog and types of catalogs in cagonos and which is better?

1009

What is the function of cognos dispatcher?

1214

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2720

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2122

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