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 Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 8992

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

IBM,

4 11129

If I have a index defined on target table and if set it to bulk load will it work ?

IBM,

4 15603

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

IBM,

3 17536

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

IBM,

11 19060

how can we check whether a particular cache is static or dynamic?

InfoCepts, TCS,

1 8245

Can any one explain or sujjest some sites for scd mappings.Thank you

Wipro,

1 4952

how to write server Routine coding?

Eric,

2132

Difference between session variables and workflow variables?

Informatica,

2 20621

What are the prerequisites for join stage

2 9511

What is the use of surrogate key stage?

2 6635

Can we use target hash file as a lookup ?

3327

What are the partitioning techniques available in link partitioner?

2280

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

2233

Can you filter data in hashed file?

3780

Un-Answered Questions { Data Warehouse }

Describe an informatica powercenter?

1130

what is the difference between infile and input? : Sas-administrator

1148

What is the difference between business requirement document and use case document.

1014

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5800

how get the grand total in master-detail report?

2236

What is depict expression change?

1127

How many number of sessions can one group in batches?

1162

What is the ab initio business rules environment (bre)?

1176

What is the difference between the standard and metrics folder?

974

Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

1032

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1009

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

What is SAS?

1062

Explain the difference between detect alias and detect context?

1109

What are the components of datastage?

1124

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