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?

1059

What are materialized views & where do we use them?

1083

State the differences between shortcut and reusable transformation

1128

Explain about round-robi?

1217

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

1118

What is a materialized view log?

1049

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?

987

What are snapshots?

1036

What are the differences between sql override and update override?

1160

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

1034

Explain about hash partitioning?

1060

How many types of transformations supported by sorted input?

1297

How to fine tune mappings?

1005

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

1061

What is etl process?

989

Un-Answered Questions { Data Warehouse }

What is the difference between absolute and relative div positioning?

1103

what are the others of "bad files" and "discard files" when using sql*loader?

2199

What are all the types of report?

1145

why is sas considered self-documenting? : Sas programming

1194

Explain what is full load & incremental or refresh load?

1045

What is metric store database?

1048

What are consolidations?

969

What is the difference between order and group variable in proc report?

1493

Nls stands for what in datastage?

1245

Explain the difference between detect alias and detect context?

1148

how can you import .csv file in to sas? : Sas programming

1150

What is the difference between filter and lookup transformation?

1187

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2198

Mention what is the syntax for m_dump in abinitio?

1524

What are the transformations that are not supported in mapplet?

1091

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