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

Define repository in terms of OBIEE?

1 3355

What is the end to end life cycle of OBIEE?

1 8657

If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?

1 4558

What is connection pool and how many connection pools did you have in your last project?

1 3737

What is the purpose of Alias Tables?

1 3436

How do you define the relationship between facts and dimensions in BMM layer?

1 3711

Did you create any new logical column in BMM layer, how?

1 3261

Can you use physical join in BMM layer?

1 4373

Can you use outer join in BMM layer?

1 4470

What is level based metrics?

1 3229

What is logging level? Where can you set logging levels?

1 3367

What are different types of variables?

1 3069

What is Authentication? How many types of authentication do we have in OBIEE?

1 3225

What is object level security?

1 3498

What is data level security?

1 3118

Un-Answered Questions { Data Warehouse }

What is dimensional table? Explain the different dimensions.

1272

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

2306

Write the unconnected lookup syntax?

1153

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

1224

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

1217

Explain scd type 3 through mapping.

1076

what are the data modeling tools you have used?(polaris)

2060

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

1044

How to add default rules in transformer?

1288

What is the difference between business requirement document and use case document.

1086

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2176

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

2828

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

2772

Demonstrate experience in maintaining quality process standards?

2676

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

2344

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