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.

1285

Explain in detail scd type 2 through mapping.

1050

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

1268

Explain the different kinds of facts.

987

How do you load only null records into target?

1221

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

1080

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

1021

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

1152

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

2033

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

1025

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

1111

Briefly explain input and put function?

1089

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

1115

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

1163

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

1070

Un-Answered Questions { Data Warehouse }

what is the difference between == and eq in UNIX shell scripting?

1502

options available in sequence job to run,validate?

1326

What is data transformation manager process?

1167

What are the 5 phases in a multiload utility?

1037

What is teradata?

1161

Can you define transformer?

957

What are the areas of application?

1152

Explain fact constellation schema?

1046

Whats there in global repository

1697

Can you define metrics designer?

1062

How to provide security in frame work manager for a query subject?

964

What is the purpose of cluster analysis in data warehousing?

1012

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2167

How can we run the graph?

1075

Design a mapping to load a target table with the following values from the above source?

1352

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