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 6369

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

Accenture, GSK GlaxoSmithKline,

8 16410

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

2 10711

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

1 7187

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

Cap Gemini, Wipro,

10 19003

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

2 6068

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

3 6527

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

Cap Gemini,

2 10014

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

1 4602

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

Cap Gemini,

5 15484

how to create document in datastage?

Cap Gemini,

1 7117

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

Cap Gemini,

5 15687

What is the difference between Boxir2 and Boxir3?

1 8933

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

1 5584

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 2689

Un-Answered Questions { Data Warehouse }

Explain the mapping variable usage example in informatica

1157

What are the steps to be taken to schedule the report?

964

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1910

What do you mean by fastexport in teradata?

1000

9. What was the most complex type of report you dealt with?

2215

How does hashing happens in teradata?

1091

What does role playing dimension mean?

1044

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322

What are the types of facts in microstrategy?

1032

How to eliminate duplicate rows from flat file?

940

Explain about a task that really tested your analytical abilities?

1245

What is the role of unrestrictive users? : sas-grid-administration

1008

What is rank transformation?

991

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1037

What is meant by target load plan?

974

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