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 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

What are the differences between oltp and olap?

972

What are the types of schemas we have in data warehouse and what are the difference between them?

941

Differentiate between reusable transformation and mapplet.

1094

Why update strategy and union transformations are active?

1042

What is meant by target load plan?

974

How to join three sources using joiner?

1115

How do you update the records with or without using update strategy?

1115

What are the differences between source qualifier and joiner transformation?

1062

How do you convert single row from source into three rows into target?

1157

What are the types of schemas we have in data warehouse.

963

Why update strategy and union transformations are active? Explain with examples.

1240

How do you remove duplicate records in informatica?

1 1384

How do you load alternate records into different tables through mapping flow?

1869

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

1159

Un-Answered Questions { Data Warehouse }

What is the function of look up transformation?

1123

How would you identify a macro variable?

1092

Explain is there any comparison available for cognos reportnet vs crystal reports?

965

Differentiate between datastage and datastage tx?

1051

What is set to be cardinality?

1174

Explain the types of join supports by teradata?

995

Explain what task is 98% of the required work of a business analyst?

1103

What is the project in datastage?

1114

how to add a new records into source?

2000

What is zero-foot print?

1019

Can you explain the co>operating system’s processing model?

1098

How many Key we can define in remove duplicate stage?

1386

What are initial page components of Cognos connection?

1013

What do you understand by the term 'model durability'?

1015

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3024

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