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?

1182

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,

1095

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,

1126

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 }

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2293

where are the log files generally stored.Can you change the path of the file.what can the path be?

2439

why a stop statement is needed for the point= option on a set statement?

1078

Tell me about % include and % eval? : sas-macro

1144

What is drill down and slicing and dicing whats the difference between them?

1073

What is main advantage datawarehousing over oracle?

1004

What is difference between a gateway node and worker node?

1137

Define report item?

1175

How can we delete duplicate rows from flat files?

1223

Explain what are the methodologies of data warehousing?

926

How the users created differs from rpd/answers/dashboards level?

816

Explain which are the olap tools available that are supported by oracle?

1009

What are the types of data warehouses?

1526

What is m_dump?

1232

is there any difference between operational database and data base?if yes what r they?

2066

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