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 are the differences between datastage and informatica?

1130

Explain the importance of surrogate key in data warehousing?

1146

How to implement complex jobs in data stage?

1070

Difference between server jobs & parallel jobs?

1029

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1217

What are the functionalities of link collector?

1050

What is the purpose of pivot stage?

1114

When do we analyze the tables?

919

What is full load & incremental or refresh load?

1171

What is tracing level?

1020

what is a worklet?

938

When do we analyze the tables? How do we do it?

915

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

934

What is etl process? How many steps etl contains?

979

How many steps etl contains?

894

Un-Answered Questions { Data Warehouse }

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1100

When do you use sql override in a lookup transformation?

1042

What do you mean by worklet?

1032

Explain clustering?

905

Define repository tables in datastage?

1120

What is a table alias in obiee 11g? Where and how will you create it?

955

What is rank transformation in informatica

1121

Explain the aggregator transformation?

1109

-----------Diff b/w OLAP and RDBMS?

2013

How to create the source and target database connections in server manager?

1050

When we save a report in report studio with what extn it save?

1012

how to read the variables in sas? : Sas-administrator

979

What does command task mean?

1081

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1047

What are the functions of a teradata dba?

1041

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