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

Explain about cumulative Sum or moving sum?

Informatica,

1043

Explain lookup transformation source types in informatica

Informatica,

1097

What is a transaction control transformation?

Informatica,

1207

Define mapping and session?

Informatica,

1033

Design a mapping to load the cumulative sum of salaries of employees into target table?

Informatica,

1505

How to create or import flat file definition in to the warehouse designer?

Informatica,

1068

What are ETL Tools?

Informatica,

1117

What are the types of data warehouses?

Informatica,

1526

How to partition the Session?

Informatica,

1113

How to create Target definition for flat files?

Informatica,

1221

How do you handle two sessions in Informatica

Informatica,

1164

What are the guidelines to be followed while using union transformation?

Informatica,

1142

Which transformation should we use to normalise the COBOL and relational sources?

Informatica,

1208

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

Informatica,

1081

What is aggregate cache in aggregator transformation?

Informatica,

1145

Un-Answered Questions { Data Warehouse }

Describe the impact of several join conditions and join order in a joiner transformation?

1062

What is a mapping?

985

Triggers,VIEW,Procedures

1220

what is the difference between == and eq in UNIX shell scripting?

1500

Explain what are conformed dimensions?

1088

How do you determine the number of sessions?

1062

Can we create Hierarchies in generic datasources?

2382

What is the size of the cube?

973

server hot-ws270 is connect to Repository B. What does it mean?

2564

How to generate iqd file from framework manager?

961

how to create user defined function (udf) in informatica

1305

what is the limit of string length in turbo integrator?

What is the difference between view filter and report filter?

923

What are cluster analysis in data warehousing?

1107

What is olap (on-line analytical processing?

1069

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