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

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

Explain in detail scd type 2 through mapping.

1041

How do you load unique records into one target table and duplicate records into a different target table?

1259

Explain the different kinds of facts.

981

How do you load only null records into target?

1216

What is fact table? Explain the different kinds of facts.

1076

How many ways are there to do 'remove duplicate records in informatica'?

1014

How to join three sources using joiner? Explain though mapping flow.

1147

How do you load only null records into target? Explain through mapping flow.

2027

I have a dataset concat having variable a b & c. How to rename a b to e & f?

1022

How do you specify the number of iterations and specific condition within a single do loop?

1103

Briefly explain input and put function?

1081

Give some examples where proc report’s defaults are same as proc print’s defaults?

1113

What is the length assigned to the target variable by the scan function?

1155

What is the difference between one to one merge and match merge? Give an example.

1067

Un-Answered Questions { Data Warehouse }

What is a data processing cycle and what is its significance?

1218

How to schedule the report in b.o?

1034

How can you write parallel routines in datastage PX?

1015

What is the use of incremental aggregation? Explain me in brief with an example?

1023

what are the errors faced while bursting the reports and how to solve those errors?

2017

What is decode in informatica?

1162

explain abt ur project architecture?

2194

How to optimize a report in microstrategy environment?

967

How do you handle two sessions in Informatica

1164

Which versions are used in the bo dashboard work?

1053

Can you filter data in hashed file?

3772

What could be the possible resons of locks by user?

1094

What are differences between different versions of co-op?

1208

What is "fatal error/rdbms code 3996" error?

1266

From where u get the logical query of your request?

781

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