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 21380

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

1 6675

what is polling?

Informatica,

1 7122

what is difference between dimention table and fact table?

1 8470

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

Patni, TCS,

4 31961

How to import oracle sequence into Informatica?

Satyam,

3 16831

What is data merging,data cleansing,sampling?

4 10221

What is IQD file?

1 5524

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

1 9227

what is the exact meaning of domain?

3 23481

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

1 4806

What is the difference between Power Centre and Power Mart?

TCS,

5 21301

why dimenstion tables are denormalized in nature ?

3 9449

What is the use of incremental aggregation?

2 10032

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

1 8773

Un-Answered Questions { Data Warehouse }

What is defined as Cognos Impromptu?

1031

What are the advantages of cold fusion?

911

How do you run datastage job from the command line?

1038

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5607

which one is better performance wise joiner or look up

1034

How to provide security in frame work manager for a query subject?

918

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1742

What is SAS?

997

Can you explain repository tables in datastage?

1346

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2177

How the ipc stage work?

1088

What is an enterprise?

983

What are the various reporting tools in the market?

1000

Explain the term 'tables' related to relational database management system?

979

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2038

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