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 21379

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

1 6674

what is polling?

Informatica,

1 7119

what is difference between dimention table and fact table?

1 8469

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

Patni, TCS,

4 31956

How to import oracle sequence into Informatica?

Satyam,

3 16827

What is data merging,data cleansing,sampling?

4 10221

What is IQD file?

1 5522

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

1 9224

what is the exact meaning of domain?

3 23477

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

1 4803

What is the difference between Power Centre and Power Mart?

TCS,

5 21295

why dimenstion tables are denormalized in nature ?

3 9448

What is the use of incremental aggregation?

2 10028

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

1 8772

Un-Answered Questions { Data Warehouse }

What is the difference between nodupkey and nodup options?

982

What are fundamental stages of data warehousing?

996

What are the components of ascential data stage?

1119

What are the features of complex mapping?

1103

Can you define query studio?

918

Difference between project merge and object manager?

959

How sas treats the dsd delimiters?

1160

Explain about a task that really tested your analytical abilities?

1193

What are the different servers in sas? : sas-grid-administration

1012

What are the fundamental blocks of co> operating system of ab initio?

1203

Explain what are the advantages and disadvantages of reporting directly against the database?

963

Differences between where and if statement?

1029

What is maximum number of rows and cols can be handled in SAS?

1492

What do you mean by static and local variable?

909

Explian the Process of deployment groups in informatica

1000

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