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 what does level of granularity of a fact table signify?

1 1024

What is ods (operation data source)?

1 1073

What is data validation strategies for data mart v?

1 1201

Explain what are fact, dimension, and measure?

1 1077

Explain why denormalization is promoted in universe designing?

1 1015

What is latest version of power center / power mart?

1 1172

What is partitioning? What are the types of partitioning?

1 1270

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

1 989

What is an er diagram?

1 1122

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

1 989

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1 1086

Explain why should you put your data warehouse on a different system than your oltp system?

1 1017

What is the difference between ods and oltp?

1 1106

Explain difference between view and materialized view?

1 1036

How to design file watch jobs?

1 1032

Un-Answered Questions { Data Warehouse }

EXL informatica Questions

1460

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1239

What is the purpose of Dataware Control?

1120

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

What is node? How many nodes and amps used in your previous project?

1173

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2262

What is aggregate table and aggregate fact table ... Any examples of both?

1118

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8284

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2207

Explain in detail about scd type 1 through mapping.

1646

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

2169

What is rollup component?

1331

How to add default rules in transformer?

1284

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