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?

946

What are materialized views & where do we use them?

943

State the differences between shortcut and reusable transformation

1010

Explain about round-robi?

1089

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

1029

What is a materialized view log?

959

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?

892

What are snapshots?

942

What are the differences between sql override and update override?

1040

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

911

Explain about hash partitioning?

939

How many types of transformations supported by sorted input?

1160

How to fine tune mappings?

893

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

941

What is etl process?

884

Un-Answered Questions { Data Warehouse }

How do you see a ddl for an existing table?

975

What is a linked cube?

947

What is domain in terms of informatica?

972

can you please explain me pre session and post session options?

7451

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

972

How to include or exclude specific variables in a data set?

1082

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1380

Can you define fan trap?

1231

Which is the t/r that builts only single cache memory?

1142

is data integration and etl programming is same? : Sas-di

1027

Why we use repository connectivity?

941

Explain Teradata performance tuning and optimization?

1120

How many types of stage?

1140

Is there any difference in testing database and data ware housing?

2716

How we can monitor the performance of Redshift data warehouse cluster.

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