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

Do we need an ETL tool? When do we go for the tools in the market?

957

Compare ETL & Manual development?

948

What are the different Lookup methods used in Informatica?

916

What are the types of Data Warehouse applications?

1023

What are the key benefits of ETL Testing?

1049

What is cube grouping?

1083

What is virtual Data Warehousing?

980

What are the modules in Power Mart?

961

Define slowly changing dimensions (SCD)?

1060

What is the difference between Data Warehousing and Data Mining?

1055

How one source columns or rows to be loaded in to two different tables?

1130

What is a merge?

1169

Why fact table is in normal form?

1249

Whats difference betweeen operational data stage (ods) and data warehouse?

1114

How the ipc stage work?

1127

Un-Answered Questions { Data Warehouse }

What is option by which we can run all the sessions in a batch simultaneously?

1141

list and discuss two approaches for updation of target table in Informatica and how they are different.

2107

Difference between project merge and object manager in microstrategy?

993

What is collect statistics?

998

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1169

How many numbers of sessions can one group in batches?

1064

what is the difference between informatica6.1 and infomatica7.1

2274

Explain sessions?

1056

How many types of sorting methods are available in datastage?

1073

How do you optimize reports in microstartegy?

1109

how can I test reports in cagnos?

1153

Describe data concatenation?

1082

How we are going to decide which schema we are going to implement in the data warehouse?

832

What do you mean by data sorting?

1204

What is informatica?

1155

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