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

If you want to create indexes after the load process which transformation you choose?

HCL,

3 21528

what happens if you try to create a shortcut to a non- shared folder?

1 6764

what is polling?

Informatica,

1 7227

what is difference between dimention table and fact table?

1 8548

what is worklet and what use of worklet and in which situation we can use it?

Patni, TCS,

4 32160

How to import oracle sequence into Informatica?

Satyam,

3 17003

What is data merging,data cleansing,sampling?

4 10392

What is IQD file?

1 5614

How do you handle decimal places while importing a flatfile into informatica?

1 9309

what is the exact meaning of domain?

3 23618

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 4899

What is the difference between Power Centre and Power Mart?

TCS,

5 21522

why dimenstion tables are denormalized in nature ?

3 9594

What is the use of incremental aggregation?

2 10144

What is the procedure to load the fact table.Give in detail?

1 8858

Un-Answered Questions { Data Warehouse }

What is the difference between match merge and one to one merge?

1248

Explain what are data marts?

1120

Explain the use lookup tables and Aggregate tables?

977

Explain what are the vaious etl tools in the market?

942

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2219

How many types of facts and what are they?

1018

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

933

Explain some differences between mpp and smp?

1099

Why cognos decision stream is used?

1159

Explain pushdown optimization $pushdownconfig parameter - informatica

1135

What is surrogate key? Explain with examples.

1158

Highlight the need for Performance Tuning.

1103

Explain the definition of normalized and denormalized view and what are the differences between them?

924

What is the importance of eme in abinitio?

1135

How to export mappings to the production environment?

907

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