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 6491

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

Accenture, GSK GlaxoSmithKline,

8 16710

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

2 10839

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

1 7303

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

Cap Gemini, Wipro,

10 19366

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

2 6168

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

3 6688

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

Cap Gemini,

2 10136

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

1 4691

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

Cap Gemini,

5 15711

how to create document in datastage?

Cap Gemini,

1 7219

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

Cap Gemini,

5 15958

What is the difference between Boxir2 and Boxir3?

1 9026

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

1 5687

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 2774

Un-Answered Questions { Data Warehouse }

What is a sparse index?

1129

How is cognos model organization works?

1171

Copy ".roi" file of management console to another path of management console's folder using ".rox" file. or any command of actuate. Is it Possible? if Yes then pls give me Example.

3003

How do you use reject loader.

2658

how to create cubes in transformer ?

1128

What are initial page components of Cognos connection?

1053

What do the mod and int function do? : Sas programming

1317

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1070

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5509

What are various warehousing tools?

1080

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1023

What is Operational Data Store?

1120

What is the ab initio business rules environment (bre)?

1232

What are the etl testing operations includes?

1169

describe the Steps to confiure a Qlogic switch

2442

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