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

What is the sequence generator transformation in informatica?

1191

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1138

State the limitations where we cannot use joiner in the mapping pipeline?

1078

What if the source is a flat-file?

1125

What is the difference between source qualifier transformations source filter to filter transformation?

1062

Write the different tools in the workflow manager?

1078

What is an expression transformation in informatica?

1048

Explain the types of lookup transformation?

1056

How we can confirm all mappings in the repository simultaneously?

1 1464

Which is the t/r that builts only single cache memory?

1198

Why filter transformation is an active one?

993

What are the components of the workflow manager?

1148

If informatica has its scheduler why using third party scheduler?

1276

How can you increase the performance in joiner transformation?

1206

What are the restrictions of union transformation?

1048

Un-Answered Questions { Data Warehouse }

what is sas data set?

1111

What are data validation strategies for data mart validation after loading process?

1023

What are the popular informatica products?

1019

What are some primary characteristics of teradata?

1012

Describe the impact of several join conditions and join order in a joiner transformation?

1068

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2282

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

1082

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6920

What is MODEL is Data mining world?

2627

What is zero-foot print?

1028

What is surrogate key? Where we use it? Explain with examples.

1041

Give e an example of..

2107

What is data stream and data adapter is it same are different? Explain?

980

what is sas enterprise intelligence architecture? : Sas-bi

989

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1043

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