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 is hash partition?

TCS,

3 5338

What is DTM session?

1 9275

How can you define a transformation? What are different types of transformations in Informatica?

TCS,

7 11072

What is mapplet?

1 6541

What is query panel?

1 3918

What is a look up function? What is default transformation for the look up function?

1 5168

What is difference between a connected look up and unconnected look up?

1 6743

What is staging area?

9 17355

What is data merging, data cleansing and sampling?

1 7730

What is up date strategy and what are th options for update strategy?

2 5231

OLAP architecture?

CTS, Honeywell,

1 6039

What is subject area?

2 10625

Why do we use DSS database for OLAP tools?

3 10642

What is ?Data Warehousing??

Accenture,

3 6609

What are Data Marts?

2 5830

Un-Answered Questions { Data Warehouse }

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

962

What is a Transformer?

1077

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2103

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1009

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1041

Can you define cognos impromptu?

1029

define drill through?

Explain proc univariate?

1031

How co> operating system natively processes the data?

1098

What are the differences between datastage and informatica?

1177

Differences between business objects and web intelligence reports?

1223

How many ways are there to do 'remove duplicate records in informatica'?

1014

What are the different options available for update strategy?

1003

Tell me what is degree of a relation?

997

Where the datastage stored his repository?

1089

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