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

What is a mapping?

985

What are materialized views & where do we use them?

997

State the differences between shortcut and reusable transformation

1056

Explain about round-robi?

1145

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1074

What is a materialized view log?

997

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

933

What are snapshots?

980

What are the differences between sql override and update override?

1100

What is partitioning? Explain about round-robin, hash partitioning.

963

Explain about hash partitioning?

1000

How many types of transformations supported by sorted input?

1222

How to fine tune mappings?

941

What is a mapping, session, worklet, workflow, mapplet?

985

What is etl process?

936

Un-Answered Questions { Data Warehouse }

What are products of cognos?

974

How can we handle two sessions in informatica?

1032

What are the various transformation available?

1012

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

968

Define joiner transformation?

1049

how we can generate cubes in cognos?

Quickly characterize reusable change?

1119

Where is metadata stored?

1112

What is status code in informatica?

1019

What is ab initio enterprise meta>environment (eme)?

1539

Can sorting and storing be done through single software or you need different for these approaches?

1117

How do I create and delete a cluster in aws redshift?

Explain the differences between normalizer and normalizer transformation?

1020

Difference between Data and Index Caches?

1137

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1143

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