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 21529

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 8549

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

Patni, TCS,

4 32169

How to import oracle sequence into Informatica?

Satyam,

3 17007

What is data merging,data cleansing,sampling?

4 10393

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 23619

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

1 4904

What is the difference between Power Centre and Power Mart?

TCS,

5 21523

why dimenstion tables are denormalized in nature ?

3 9594

What is the use of incremental aggregation?

2 10145

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

1 8858

Un-Answered Questions { Data Warehouse }

How did you plan your Data ware house project?

2306

Did you used proc test? when?

2040

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038

When to use local filter and when to use global filter?

996

What if the source is a flat-file?

1111

COM components can be used in Informatica

2390

In development project what is the process to follow for an etl developer from day1

1724

what is requery in cognos?

2483

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058

What is merge stage?

1314

What do you mean by static prompt report?

988

Explain grouped cross tab?

2626

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1390

Difference between output_index and output_indexes in reformat

1296

How would you format some text using css to be verdana and bold?

1076

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