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

Which are the olap tools available that are supported by oracle?

1 997

What is the difference between olap and datawarehosue?

1 1030

Explain what are the different types of join operations?

1 1043

Explain the different types of data warehousing?

1 1052

Explain what are non-additive facts in detail?

1 1102

What is is a star schema?

1 1300

Explain what is a view as it relates to system modeling?

1 1054

Explain what are slowly changing dimensions?

1 1096

I know of using applysimple, but there are other ways too?

1 1014

Explain what are the various methods of getting incremental records or delta records from the source systems?

1 1041

Why denormalization is promoted in universe designing?

1 1055

Explain what are the various transformation available?

1 1097

How to reduce warnings?

1 999

What is the difference between a primary and secondary actor in use case modeling?

1 1155

Explain what is partitioning? What are the types of partitioning?

1 1029

Un-Answered Questions { Data Warehouse }

faq's on cognos

4112

Write the unconnected lookup syntax and how to return more than one column.

1174

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

2127

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

What is a rollup component? Explain about it.

1242

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

Write the unconnected lookup syntax?

1146

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2093

What r the names of the reports that you prepared?

1029

EXL informatica Questions

1460

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

1176

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

Explain about a time when you discovered a more efficient way to do a work task?

1222

What is rollup component?

1331

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2793

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