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?

1250

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

1194

Differentiate between hash file and sequential file?

1134

Define project in datastage?

1153

How to clean the datastage repository?

1183

How rejected rows are managed in datastage?

1578

Does datastage support slowly changing dimensions ?

1160

How many types of hash files are there?

1240

Nls stands for what in datastage?

1238

Define meta stage?

1262

Define orabulk and bcp stages?

1180

Define repository tables in datastage?

1211

How complex jobs are implemented in datstage to improve performance?

1099

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

1550

How a routine is called in datastage job?

1167

Un-Answered Questions { Data Warehouse }

what is diff b/t sorter t/r and agg have the option sorter property...

2237

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1071

Explain how you can run a graph infinitely in ab initio?

1169

How is possible this scenario using in type-in prompt.?

1103

What is package in BO

3254

Explain what is informatica metadata and where is it stored?

1116

What are the components of Informatica? And what is the purpose of each?

1113

How rejected rows are managed in datastage?

1578

Explain and compare pros and cons of start schemas?

1153

what is power prompt in cognos ep7series?what is the use of this?

3737

Explain the difference between filter and conditin?

1017

What are pass-through functions and why they are so called? Give some examples.

1110

What are the tasks that source qualifier perform?

1145

Slowly changing dimensions, types and where will you use them

1774

How to include or exclude specific variables in a data set?

1169

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