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 bus schema?

1 1036

Explain what are the possible data marts in retail sales?

1 1075

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

1 1049

Explain differences between star and snowflake schemas?

1 1278

Explain vldb?

1 1094

What is incremintal loading?

1 1224

Explain hybrid slowly changing dimension?

1 1075

What is top business?

1 1171

Explain what are the steps to do to use alerts in bo?

1 1142

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1 1055

Explain what is the difference between slice and dice and cross tab report?

1 1162

Explain how to execute the plsql procedure from the report by clicking with mouse?

1 1109

Explain how to schedule the report in b.o?

1 1145

Explain the difference between detect alias and detect context?

1 1156

Explain difference between zabo and webi?

1 1157

Un-Answered Questions { Data Warehouse }

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

2261

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 dimensional table?

1159

Explain in detail about scd type 1 through mapping.

1646

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

2822

What is the purpose of Dataware Control?

1119

How do you remove duplicate records in informatica? And how many ways are there to do it?

1231

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1172

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...................................

2331

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

1212

Explain how to generate iqd file from framework manager?

1020

What is dimensional table? Explain the different dimensions.

1267

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1847

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

2206

Have you have ever worked in unix environment and why it is useful in datastage?

1212

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