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 the difference between data ware house & data mart?

1 1024

After the complete generation of a report who will test the report and who will analyze it?

1 1046

What is the difference between snowflake and star schema?

1 1110

Explain the importance of data warehouse?

1 1073

How can we run the graph? What is the procedure for that?

1 1009

What is a source qualifier?

1 1169

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

1 1039

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

1 962

What is difference between e-r modeling and dimensional modeling?

1 974

What is a hash cluster?

1 1056

What is data analysis? Where it will be used?

1 1053

What are the methodologies of data warehousing?

1 1045

What is the difference between dependent data warehouse and independent data warehouse?

1 1060

What is the difference between aggregate table and materialized view?

1 1152

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1 1480

Un-Answered Questions { Data Warehouse }

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

2480

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

1193

How to add default rules in transformer?

1277

What sort of existing documents should business analysts refer to when starting on a new project?

1074

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

2201

faq's on cognos

4108

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

2339

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

Are you involved in writing the inferential analysis plan? Tables specifications?

4011

Hi, If anyone has base SAS certification dumps, please share.

1932

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

EXL informatica Questions

1451

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

2759

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1093

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