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 a dimensional model?

996

What are the differences between a connected lookup and unconnected lookup?

1079

What is the command used to run a batch?

1079

Differences between connected and unconnected lookup?

1227

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1097

What is a joiner transformation and why it is an active one?

1100

Which development components of informatica have the highest usage?

1068

What is informatica etl tool?

1009

Differentiate between joiner and lookup transformation?

1113

What is workflow? What are the components of the workflow manager?

1155

What will be the approach?

1000

What is a snowflake schema?

1007

How will the document be delivered to me?

1096

What is a predefined event?

1103

Differentiate between mapping parameter and mapping variable?

1 1674

Un-Answered Questions { Data Warehouse }

Explain ibm infosphere information server and highlight its main features?

1105

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

962

What is the purpose of indexes?

1090

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2599

what is xcelsius architecture?

4606

what are the Methods For Creating Reusable Transformations?

1188

What is the difference between server job and parallel jobs?

1171

What do you understand by the term 'aggregate advisor?'

974

What is bteq utility in teradata?

989

Mention common programming errors committed in sas ?

1137

Difference between project merge and object manager in microstrategy?

1003

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1385

what is the way of writing a feeder statement when feeding one cube from another?

What are data-driven sessions?

1229

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

986

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