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 21689

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

1 6831

what is polling?

Informatica,

1 7327

what is difference between dimention table and fact table?

1 8612

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

Patni, TCS,

4 32327

How to import oracle sequence into Informatica?

Satyam,

3 17126

What is data merging,data cleansing,sampling?

4 10599

What is IQD file?

1 5699

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

1 9392

what is the exact meaning of domain?

3 23755

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

1 4975

What is the difference between Power Centre and Power Mart?

TCS,

5 21752

why dimenstion tables are denormalized in nature ?

3 9728

What is the use of incremental aggregation?

2 10256

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

1 8941

Un-Answered Questions { Data Warehouse }

Difference between sum function and using “+” operator?

1212

What is meant by metadata in context of a data warehouse?

1024

What do the put and input function do?

1117

Explain the term 'foreign key' related to relational database management system?

1120

Explain what is de-partition in abinitio?

1408

Explain the difference between nodup and nodupkey options?

1091

How is the number of passes in a sql query significant in performance evaluation?

1011

What are all the types of gateway used in Cognos?

1084

What are the differences between informatica and abinitio?

1271

differentiate between power play transformer and power play reports?

What is database exceptions in teradata?

1004

What are the data types does SAS contain?

1172

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1402

In SAS explain which statement does not perform automatic conversions in comparisons?

1376

Is olap services sold as a separate product?

965

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