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

How to merge the data using merge statement and proc format? Is the result is same ?

2 7210

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

IBM,

1 3003

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

TCS,

3 8757

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

TCS,

2 11818

What are Rapid changing dimensions?

1 5436

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

IBM,

9 13958

Which one is better among Value and select & search prompts,in terms of performance?

L&T,

2 7423

How to load only the first and last record of a flat file into the target?

Mind Tree,

3 9793

what are objects in data warehouse?

Mind Tree,

2 8410

what are challenges that you faced in testing? give solution to it?

1 4399

design of staging area?

2030

how can you generate sequence number using only the sequential file stage?

TIAA CREF,

3 17437

How to find value from a column in a dataset?

TIAA CREF,

2207

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

TIAA CREF,

2 7771

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

TIAA CREF,

1 7584

Un-Answered Questions { Data Warehouse }

what is a security filter?

1001

how many types prompting framework can be broken down to? : Sas-bi

1081

what is the difference between cardinality and Nullability?

2950

Explain difference between powerplay transformer and power play reports?

957

How to partition the Session?

1117

Difference between PowerPlay transformer and power play reports?

2523

Describe a data warehouse.

992

Explain datawarehousing?

1059

What are the steps to build the datawarehouse?

1040

Difference between multiload and tpump?

1118

wf dont have integration severances how you can run?

1942

How do you improve the performance of the Cognos Analytics report

1038

What is SAS informats?

1111

What are the uses of etl tools?

1130

What is pass through metrics in microstrategy?

984

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