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.

1341

Explain in detail scd type 2 through mapping.

1092

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

1321

Explain the different kinds of facts.

1026

How do you load only null records into target?

1257

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

1129

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

1067

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

1193

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

2077

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

1083

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

1160

Briefly explain input and put function?

1140

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

1168

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

1208

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

1123

Un-Answered Questions { Data Warehouse }

Explain teradata vs. Redshift?

1080

What is the advantages data mining over traditional approaches?

1026

how to do user inputs and command line arguments in sas?

3095

What do you understand by term role-playing dimension?

1121

Explain a mapping, session, worklet, workflow, mapplet?

1152

What is the difference between round-robin partitioning and hash partitioning?

1035

What are the Graph parameter?

1205

Explain constraint based loading in informatica

1157

What do you mean by caching in teradata?

1108

Explain input and put function?

1188

In banking domain how many Fact tables,Dimension table are present?

8858

What are the Types of parallelism in detail?

1195

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1966

Why facts table is useful in representing the data?

1053

what is sas business intelligence? : Sas-bi

1271

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