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

What are the tools available for etl?

972

What is the goal of optimizer?

1049

What are the different types of datawarehosuing?

991

What are the approaches used by optimizer during execution plan?

909

What needs to be done while starting the database?

1109

What is the definition of cube in datawarehousing?

992

What is the difference between er modeling and dimensional modeling?

1148

What is defined as partial backup?

1075

What are the stages of datawarehousing?

1013

What is called dimensional modelling?

1110

Can we take backup when the database is opened?

1044

What are the types of dimensional modeling?

1063

What are the steps to build the datawarehouse?

1040

What is execution plan?

1202

What needs to be done when the database is shutdown?

1026

Un-Answered Questions { Data Warehouse }

Explain the differences between normalizer and normalizer transformation?

1023

How do you Parametermap variables in Quiries?

2263

Why and when do you use proc sql?

1247

what are the different types of fact structures?

1102

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7391

What are the different options available for update strategy?

1003

What are the databases that informatica can connect to windows?

1052

What is meta data and system catalog?

2303

What are fact, dimension, and measure?

1335

describe the Steps to confiure a Qlogic switch

2383

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

930

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

2010

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2199

how does the server recongnise the source and target databases.Elaborate on this

2690

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

959

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