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 tools available for etl?

928

What is the goal of optimizer?

1004

What are the different types of datawarehosuing?

947

What are the approaches used by optimizer during execution plan?

837

What needs to be done while starting the database?

1052

What is the definition of cube in datawarehousing?

936

What is the difference between er modeling and dimensional modeling?

1079

What is defined as partial backup?

1023

What are the stages of datawarehousing?

956

What is called dimensional modelling?

1036

Can we take backup when the database is opened?

1002

What are the types of dimensional modeling?

1008

What are the steps to build the datawarehouse?

994

What is execution plan?

1160

What needs to be done when the database is shutdown?

968

Un-Answered Questions { Data Warehouse }

Explain the pipeline partition with real time example?

1088

What is apt_config in datastage?

1084

How to use pmcmd utility command?

975

What is logical data model?

1145

Can you define folder?

915

Differentiate between joiner and lookup transformation?

1056

What is collect statistics?

949

In Teradata, what is the significance of UPSERT command?

1136

Explain fastload in teradata?

1043

How to use consolidations in microstrategy report?

992

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1160

What are the functions of a Parser?

1035

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2000

What are the frequently used data types in teradata?

1008

What do you mean by mstr?

1032

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