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

Diff b/w Crossproduct and Outerjoin?

IBM, Mind Tree,

2283

What is Outerjoin?

2 4450

What is Fullouterjoin?

1983

What is Index?

2 7180

What is Crossproduct?

2 7059

How to do Performence Tunning in Cognos Reports?

2475

What is Parametermap?

2 7968

What is RenderVariable?

5 8726

What DB View and Bus View?

1974

What are Governer Settings?

2 6174

What is meant by Reportstudio shortcut?

2188

What are partitions in informatica and which one is used for better performance?

2 16014

How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 5301

Tell me about Schemas?

4 10838

What is Normalization?

3 9730

Un-Answered Questions { Data Warehouse }

Explain input and put function?

1146

How to handle multi value dimensions?

2291

Tell us about the architecture of abinitio.

1099

What is a full backup?

964

Which component has onread method and what it is used for?

984

Explain translate function?

1212

What is difference between custom hierarchy and report based hierarchy?

1019

What are all the types of indexes in Cognos?

1238

Explain fallback in teradata?

1065

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1158

What are the processing stages?

1102

What are the job parameters?

1221

how do you pull data from equifax?tell me the process?

1799

AGGREGATOR default datatype

1461

What does microstrategy intelligence server allow users to do?

988

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