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?

1177

Explain the importance of surrogate key in data warehousing?

1190

How to implement complex jobs in data stage?

1112

Difference between server jobs & parallel jobs?

1076

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

1277

What are the functionalities of link collector?

1085

What is the purpose of pivot stage?

1168

When do we analyze the tables?

967

What is full load & incremental or refresh load?

1203

What is tracing level?

1064

what is a worklet?

994

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

960

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

974

What is etl process? How many steps etl contains?

1033

How many steps etl contains?

943

Un-Answered Questions { Data Warehouse }

What is a fantrap in business objects?

1170

What are the fundamental blocks of co> operating system of ab initio?

1268

Explain about cumulative Sum or moving sum?

1043

What is difference between custom hierarchy and report based hierarchy?

1017

How to run a graph infinitely?

1121

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1965

in sap bi we have wad, then why we go for sap bo

3381

What is data mapping and data modelling?

1554

How can I load my data into Amazon Redshift from different data sources like Amazon RDS, Amazon DynamoDB and Amazon EC2?

Explain pmcmd command usage in informatica

1131

What is SAS? What are the functions does it performs?

1196

What is a logical size of a table and what does it depend on?

967

What are the difference between the sas data step and sas procs?

1186

What is the importance of having monitor service in cognos?

1035

what is the difference between cardinality and Nullability?

2943

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