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.

1804

What are the differences between oltp and olap?

1018

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

991

Differentiate between reusable transformation and mapplet.

1147

Why update strategy and union transformations are active?

1101

What is meant by target load plan?

1032

How to join three sources using joiner?

1201

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

1164

What are the differences between source qualifier and joiner transformation?

1137

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

1216

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

1008

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

1288

How do you remove duplicate records in informatica?

1 1459

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

1929

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

1215

Un-Answered Questions { Data Warehouse }

How can we use batches?

1066

What is the difference between Active and Passive transformation?

1225

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1059

What is the differences between star and snowflake schemas?

1121

What are the names of the layers in etl?

1045

What is conformed fact?

1155

What are prompted filters?

995

Mention a few design and development best practices for informatica?

1047

Are you involved in writing the inferential analysis plan? Tables specfications?

2269

What is a bo repository?

1109

What is the difference between using drop = data set option in data statement and set statement?

1214

how can you create zero observation dataset? : Sas programming

1203

in general which algorithms for used?

2075

How will you create interactive dashboards ?

952

Explain the difference between rolap and molap?

1024

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