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?

1074

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

916

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

913

What is the purpose of cluster analysis in data warehousing?

960

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

891

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

950

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

1195

What are the different models used in cluster analysis?

914

Why facts table is useful in representing the data?

946

What is the use of dimensional modeling in data warehousing?

935

What is the function of surrogate key in data warehousing?

1011

Why is chameleon method used in data warehouse?

1120

Why is dimensional normalization not required?

1054

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

894

What is the difference between data warehouse and operational systems?

1090

Un-Answered Questions { Data Warehouse }

Compare ETL & Manual development?

906

How can users design dashboards quickly and without programming experience or training?

902

What is non-aggregate metric?

955

What are shortcuts? Where it can be used? What are the advantages?

1009

How many ways a relational source definition can be updated and what are they?

971

Explain the use lookup tables and Aggregate tables?

939

What is aggregate fact table?

945

How to use pmcmd utility command?

985

How to define a cube??

886

What is the difference between a scan component and a rollup component?

1124

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2071

what actually happens when bulk load mode starts?

What is rank transformation in informatica

1120

In proc transpose and data step with arrays which one you pick?

3065

How can we remove the duplicates from flat file source?

965

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