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

main purpose of aggregate awareness(not include make possible of use of aggregate tables)

Accenture,

2 8694

in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

Accenture,

3 9953

disadvantages of boxi

Accenture,

2 8468

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

Accenture,

2 9069

what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

Fujitsu, Virtusa,

4 14005

what is the difference btween olap and oltp?

CTS, Fujitsu,

6 18307

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 6290

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

2 9028

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 18185

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 12227

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 9320

what do u mean by variable functions ?

2 6226

what is datastage job Monitoring

CTS,

6 22740

what is usage of datastage with materialized views

HP, TCS,

4 16899

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 17398

Un-Answered Questions { Data Warehouse }

Hi friends, what are the new features in abinito3.0?

2860

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

2057

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

2104

What is node? How many nodes and amps used in your previous project?

1173

faq's on cognos

4112

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2299

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

1670

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

4192

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?

1099

What is the purpose of Dataware Control?

1119

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2060

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

What is dimensional table?

1162

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

1144

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