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 what is a cube in data warehousing concept?

1 1043

What is the difference between datawarehouse and bi?

1 1031

What is the 4 + 1 view model as it relates to system modeling?

1 1111

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1 1243

Explain what is real time data-warehousing?

1 1222

Explain what is cost benefit analysis (cba)?

1 1040

I need a good brd and uc template?

1 1159

What are the types of partitioning?

1 1107

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1 990

What is the difference between view filter and report filter?

1 980

Explain swot analysis?

1 1249

Explain me what are conformed dimensions?

1 1122

Which columns go to the fact table and which columns go the dimension table?

1 1041

What is fact less fact table? Where you have used it in your project?

1 1115

What is pre-emptive and non-pre-emptive?

1 1047

Un-Answered Questions { Data Warehouse }

What is rollup component?

1334

What is dimensional table? Explain the different dimensions.

1269

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

1079

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

1998

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

2343

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

2770

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

2824

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

2168

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

2095

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

What is dimensional table?

1165

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

4192

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

2306

Explain how to generate iqd file from framework manager?

1022

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2493

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