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

list out all the transformations which use cache?

1184

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

Informatica,

1109

What are multi-group transformations?

Informatica,

1096

Design a mapping to load a target table with the following values from the above source?

Informatica,

1346

How to load last n records of file into target table - informatica

Informatica,

1081

What is the commit type if you have a transaction control transformation in the mapping?

Informatica,

1030

How can we improve session performance in aggregator transformation?

Informatica,

1117

Explain direct and indirect flat file loading (source file type) - informatica

Informatica,

1318

What are the basic requirements to join two sources in a source qualifier transformation using default join?

Informatica,

1128

What is Data Caches size?

Informatica,

1091

How do you promote a non-reusable transformation to reusable transformation?

Informatica,

1138

Explain load alternative records / rows into multiple targets - informatica

Informatica,

1152

Explain lookup transformation in informatica

Informatica,

1073

How many ways a relational source definition can be updated and what are they?

Informatica,

1017

What are the differences between joiner transformation and source qualifier transformation?

Informatica,

1171

Un-Answered Questions { Data Warehouse }

Which are the statements whose placement in the data step is critical?

1265

What is the difference between sandbox and EME?

1267

What is a filter transformation?

1043

Explain what are slowly changing dimensions?

1024

Highlight the need for Performance Tuning.

1105

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

990

How will the AWS redshift work?

what is the size of your data warehousing?

2095

What are the new features of informatica 9.x at the developer level?

1043

Explain the shared cache and re-cache?

1116

What is the size of database for you project?

1597

What is the difference between project backlog and product backlog?

1533

Which function is used to count the number of intervals between two sas dates?

1129

What is meant by LDAP users?

1209

How do you achieve schema object version control?

999

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