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 9116

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

IBM,

4 11281

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

IBM,

4 15766

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 17652

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

IBM,

11 19462

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

InfoCepts, TCS,

1 8327

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

Wipro,

1 5030

how to write server Routine coding?

Eric,

2185

Difference between session variables and workflow variables?

Informatica,

2 20740

What are the prerequisites for join stage

2 9636

What is the use of surrogate key stage?

2 6743

Can we use target hash file as a lookup ?

3381

What are the partitioning techniques available in link partitioner?

2331

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

2298

Can you filter data in hashed file?

3828

Un-Answered Questions { Data Warehouse }

What is a rollup component?

1175

Explain PDE.

1132

How we can monitor the performance of Redshift data warehouse cluster.

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1023

What is primary and backup node?

1174

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2251

How to select multiple values from type-in prompt?

1108

What is the difference between absolute filtering and standard filtering?

1118

What is partitioning? Explain about round-robin, hash partitioning.

1033

Describe crosslist option in tables statement?

1274

Explain attribute role?

1155

Why are meta service important then other services?

1021

What is a level of granularity of a fact table?

1225

What makes sas stand out to be the best over other data analytics tools?

1119

Explain what is the architecture of abinitio?

1264

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