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.

1223

Explain in detail scd type 2 through mapping.

991

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

1166

Explain the different kinds of facts.

935

How do you load only null records into target?

1145

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

1012

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

956

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

1092

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

1958

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

964

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

1052

Briefly explain input and put function?

1032

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

1057

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

1097

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

999

Un-Answered Questions { Data Warehouse }

What areas of SAS are you most interested in?

1476

How to connect a private redshift cluster?

What is a quality stage in datastage tool?

1025

How to add default rules in transformer?

1159

What are the main features of datastage?

1208

how to export or import the jobs in .ISX file

1133

can anyone suggest best free Talend data integration training online

1623

Explain what is the difference between datawarehouse and bi?

905

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

918

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1030

What is the use of hoursfromtime() function in transformer stage in datastage?

1001

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1967

How can a transformation be made reusable?

1079

Can you highlight the main features of ibm infosphere information server?

1046

What is vldb(very large databases)?

946

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