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 type of reports you are generating in your company...???

GSK GlaxoSmithKline,

2 6371

if we dont want to print output what we have to do..???give syntax..???

Accenture, GSK GlaxoSmithKline,

8 16420

What are aggregate fact tables ? why they are needed? give an example

2 10715

State any 5 of Cods guidelines of an OLAP system, brief description each?

1 7191

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

Cap Gemini, Wipro,

10 19010

how to improve performence by using sorted input in aggrigator t/r.

2 6071

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 6529

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

Cap Gemini,

2 10016

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 4603

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

5 15487

how to create document in datastage?

Cap Gemini,

1 7121

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 15694

What is the difference between Boxir2 and Boxir3?

1 8934

wha is the difference b/w merge dimension and combining two different data providers?

1 5589

Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?

1 2691

Un-Answered Questions { Data Warehouse }

Explain difference between snow flake and star schema.

1050

what is pmrep command?

2438

tell me few points when u become TL

2556

Mention the validation tools used in SAS?

1181

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2615

Define cognos report net?

976

which date function advances a date, time or datetime value by a given interval? : Sas programming

1051

What is an Integration service in Informatica?

1136

In document how to create metrics?

992

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1260

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

949

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1067

What is drilling across?

994

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7245

Why union transformation is an active transformation?

1048

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