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 8519

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 9763

disadvantages of boxi

Accenture,

2 8343

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

Accenture,

2 8931

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 13813

what is the difference btween olap and oltp?

CTS, Fujitsu,

6 17999

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

1 6170

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 8907

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 17823

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

3 12057

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 9114

what do u mean by variable functions ?

2 6085

what is datastage job Monitoring

CTS,

6 22477

what is usage of datastage with materialized views

HP, TCS,

4 16622

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 16822

Un-Answered Questions { Data Warehouse }

if you use oracle sql*loader , how do you transform data with it during loading?

2100

What are the different methods of loading dimension tables?

995

How will you enable or disable caching in the system level and table level?

894

--------------Diff b/w ODS and OLAP?

3207

How is possible this scenario using in type-in prompt.?

1057

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2081

what is power prompt in cognos ep7series?what is the use of this?

3689

where to store informatica rejected data? How to extract the informatica rejected data?

1007

Terminate Activity

1280

4. How many dimensions did you use in your reports?

1953

What all are the different way to run a job?

1094

what is granularity in Data ware House?

1726

tell me few points when u become TL

2556

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

961

tell me the rules and responsblites in our project(my project is development)

1933

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