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?

1006

What are the different types of datawarehosuing?

950

What are the approaches used by optimizer during execution plan?

839

What needs to be done while starting the database?

1055

What is the definition of cube in datawarehousing?

938

What is the difference between er modeling and dimensional modeling?

1082

What is defined as partial backup?

1023

What are the stages of datawarehousing?

957

What is called dimensional modelling?

1039

Can we take backup when the database is opened?

1004

What are the types of dimensional modeling?

1010

What are the steps to build the datawarehouse?

995

What is execution plan?

1164

What needs to be done when the database is shutdown?

971

Un-Answered Questions { Data Warehouse }

What is workflow? What are the components of workflow manager?

1129

Mention a few of the ETL tools that come under Teradata.

1022

What is the difference between regular dimension and derminant?

2204

What is a partition?

1117

If a Node is busy what are the steps you can take to avoid ?

2352

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1002

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

992

Can you define fan trap?

1228

Is it possible to access Redshift compute Nodes directly?

What are dimensions?

993

What are different types of transformations available in informatica?

945

Explain fastload in teradata?

1048

What are various types of gateways in cognos?

980

do you need to know if there are any missing values? : Sas programming

994

How to restrict password to a user while sending a document in .pdf format

2278

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