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.

1242

Explain in detail scd type 2 through mapping.

1005

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

1180

Explain the different kinds of facts.

950

How do you load only null records into target?

1164

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

1036

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

973

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

1112

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

1980

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

989

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

1067

Briefly explain input and put function?

1054

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

1079

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

1127

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

1017

Un-Answered Questions { Data Warehouse }

How to stop a batch?

932

Explain proc univariate?

993

What is a sorter transformation?

1060

What are the different log files in obiee?

921

What is standalone command task?

1283

What is the function that transfers a string into a decimal?

1110

What do you know about sas data set?

1056

what is the difference between unique key and primary key? : Sas-di

1088

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1347

Explain the special input delimiters used in sas programming.

977

Explain what are the different types of transformation available in informatica.

1078

What is main advantage datawarehousing over oracle?

970

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2308

Explain what is the difference between a primary and secondary actor in use case modeling?

1035

What is the maplet?

1068

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