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 5470

What is DTM session?

1 9362

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

TCS,

7 11356

What is mapplet?

1 6627

What is query panel?

1 4019

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

1 5267

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

1 6806

What is staging area?

9 17632

What is data merging, data cleansing and sampling?

1 7831

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

2 5361

OLAP architecture?

CTS, Honeywell,

1 6127

What is subject area?

2 10775

Why do we use DSS database for OLAP tools?

3 10751

What is ?Data Warehousing??

Accenture,

3 6755

What are Data Marts?

2 5953

Un-Answered Questions { Data Warehouse }

how do u extract data from different data sources explain with an example?

2333

what is Active lock explain

2859

What is catalog and types of catalogs in cagonos and which is better?

1089

what type of raid setup would you put your tx logs?

1000

How do you load only null records into target? Explain through mapping flow.

2077

What is data partitioning?

1273

What is depict expression change?

1200

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2148

Can you define dimension?

1138

what is pmrep command?

2486

What is the conflict resolution window?

1127

What are constraints and derivations?

1215

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1209

What is the role of sas grid administrator? : sas-grid-administration

1350

Explain 4gt switch?

961

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