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 are the tasks that source qualifier performs?

1 7076

What is the target load order?

HCL, Informatica,

3 13644

What is the default join that source qualifier provides?

Informatica,

3 14210

What are the basic needs to join two sources in a source qualifier?

4 13293

what is update strategy transformation ?

TCS,

7 24428

Describe two levels in which update strategy transformation sets?

1 9397

What is the default source option for update stratgey transformation?

1 7385

What is Datadriven?

Informatica,

2 8863

What are the options in the target session of update strategy transsformatioin?

2 10826

What are the types of maping wizards that r to be provided in Informatica?

2 8367

What are the types of maping in Getting Started Wizard?

1 5976

What are the mapings that we use for slowly changing dimension table?

2 11000

What are the different types of Type2 dimension maping?

1 5726

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 8898

What are two types of processes that informatica runs the session?

2 19463

Un-Answered Questions { Data Warehouse }

Explain is there any other repository domains rather than universe, security, document?

1182

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2350

What do you mean by teradata sql assistant?

1115

What is the difference between static cache and dynamic cache?

1068

How is the number of passes in a sql query significant in performance evaluation?

1011

Can you pass sql queries in filter transformation?

1076

How do you reject records in a transformer?

1181

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

1057

What are the join problems comes appart from loop,chasm & fan Traps

2193

Explain degenerate dimension table?

1106

AGGREGATOR default datatype

1528

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2175

What is loop in data warehousing?

1204

what are factless facts? And in which scenario will you use such kinds of fact tables.

1863

What exactly do you know about the typical data analysis?

1154

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