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?

987

What are materialized views & where do we use them?

998

State the differences between shortcut and reusable transformation

1056

Explain about round-robi?

1148

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?

998

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 }

How can users design dashboards quickly and without programming experience or training?

959

Explain the difference between native sql and cognos sql?

1017

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2138

How to load last n records of file into target table - informatica

1081

what is model and say about process how to create model and how to test model?

1061

What Proc glm does?

1085

How to sort in descending order?

1257

What is surrogate key? Where we use it? Explain with examples.

1027

Do we need an etl tool?

1009

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2395

Can we get 1st record through Informatica(without sequence number).

1479

what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

2509

What is the information present in the cognos configuration file?

958

Explain the difference between holap and rolap?

979

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2219

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