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 does command task mean?

1 1231

What do you mean by enterprise data warehousing?

1 1113

What is complex mapping?

1 1184

What are the different types of olap? Give an example?

1 1099

Explain the code page compatibility?

1 1127

Briefly define a session task?

1 1209

Briefly describe lookup transformation?

1 1101

How can you validate all mappings in the repository simultaneously?

1 1433

Where can we find the throughput option in informatica?

1 1125

What is meant by pre and post session shell command?

1 1213

Explain about core dimension, balanced dimension, and dirty dimension?

1 1065

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1 1144

Can informatica load heterogeneous targets from heterogeneous sources?

1 1247

Can we override a native sql query within informatica?

1 1099

Where is metadata stored?

1 1204

Un-Answered Questions { Data Warehouse }

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

1167

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.

1231

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2814

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4183

what are the names of the reports that you prepared?

1185

Explain scd type 3 through mapping.

1065

explain in detail about type 3?

1078

how many reports have u created ? explain a few.

2152

How would you format some text using css to be verdana and bold?

1133

faq's on cognos

4108

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

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

2163

Are you involved in writing the inferential analysis plan? Tables specifications?

4011

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

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