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?

1257

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.

2022

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

1020

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 }

How many types of nodes supported by Redshift and what are the functions of nodes?

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2233

what is the Default Source Option For Update Strategy Transformation?

1239

what are the names of the reports that you prepared?

1106

What is $mpjret?

1149

Explain rw document?

1099

How do you load first and last records into target table?

1159

Explain the difference between informat and format with an example.

1168

What do mean by local and global repository?

1226

What are the advantages of using cognos sql?

1194

Explain what are the different types of data warehousing?

963

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

What makes sas stand out to be the best over other data analytics tools?

1069

What is source qualifier transformation in informatica?

1009

How we can create indexes after completing the load process?

1160

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