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

Why fact table is in a normal form?

1 1042

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

1 1031

How to load the time dimension?

1 1084

What are the advantages of raid 1, 1/0, and

1 1038

Where do we use semi and non additive facts?

1 1057

In microstrategy, how can we direct the sql generated to use a specifc table?

1 1117

Explain the main differences between star and snowflake schema?

1 1060

Explain me what are data marts?

1 1125

Explain what is type 2 version dimension?

1 1073

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1 1112

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

1 1136

How are the dimension tables designed?

1 1063

What is cubes?

1 1120

What is analytical or analytic mean?

1 1204

What are non-additive facts in detail?

1 1070

Un-Answered Questions { Data Warehouse }

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1996

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

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

1174

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

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

2104

how to generate the test data in sas without input data? : Sas-administrator

1202

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

8284

Explain about a tricky situation for which you found a very simple solution?

1077

What is a rollup component? Explain about it.

1242

How to create the source and target database connections in server manager?

1144

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

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

2167

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

1769

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

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