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?

1231

Explain the importance of surrogate key in data warehousing?

1241

How to implement complex jobs in data stage?

1167

Difference between server jobs & parallel jobs?

1139

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

1361

What are the functionalities of link collector?

1148

What is the purpose of pivot stage?

1240

When do we analyze the tables?

1027

What is full load & incremental or refresh load?

1255

What is tracing level?

1143

what is a worklet?

1041

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

1012

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

1030

What is etl process? How many steps etl contains?

1094

How many steps etl contains?

995

Un-Answered Questions { Data Warehouse }

Explain the ab initio etl tool in high level?

1214

What is the sortmerge collector?

1180

List few etl bugs?

1004

Can informatica load heterogeneous targets from heterogeneous sources?

1245

What is Redshift Enhanced VPC Routing?

Plz can any one say me how to get the informatica certification materials and dumps

2107

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

1112

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2171

What is the maximum length of the macro variable?

1232

Does an informatica transformation support only aggregate expressions?

1096

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1129

What is star schema and snowflake schema?

1072

Why do you think data processing is important?

1175

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1053

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

7695

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