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

Whether dimension table can have numeric value?

1056

Have you have ever worked in unix environment and why it is useful in datastage?

1086

Differentiate between hash file and sequential file?

1003

Define project in datastage?

1053

How to clean the datastage repository?

1071

How rejected rows are managed in datastage?

1450

Does datastage support slowly changing dimensions ?

1057

How many types of hash files are there?

1123

Nls stands for what in datastage?

1147

Define meta stage?

1147

Define orabulk and bcp stages?

1071

Define repository tables in datastage?

1103

How complex jobs are implemented in datstage to improve performance?

967

Can you explain how could anyone drop the index before loading the data in target in datastage?

1446

How a routine is called in datastage job?

1045

Un-Answered Questions { Data Warehouse }

define sparse cube?

How to move or copy the project parameter or project object to my sandbox?

2258

what is the meaning of ending bulk load mode?

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

1736

What are attribute roles?

924

What is a datastage job?

968

How to fine tune mappings?

881

What are the data movement modes in informatica?

1085

Mention few advantages of router transformation over filter transformation.

985

What is ab initio enterprise meta>environment (eme)?

1464

Can you define a query subject?

981

How to find value from a column in a dataset?

2150

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

888

What do you understand by the term ‘transformation’?

961

How to improve session performance in aggregator transformation?

935

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