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

Separate from an archive server and a powerhouse?

962

Make a note of the quantity vaults made in informatica?

988

How is union transformation utilized?

1009

What is meant by incremental aggregation?

1106

Different qualification between a related rotate toward the sky and isolates look upward?

986

Clarify the aggregator change?

1028

What is joiner change?

1146

What is lookup change?

1048

How might one distinguish in the case of mapping is right or not without associating session?

1119

What does cheating measurement mean?

1061

Separate from a database, an information bazaar, and an information stockroom?

1089

What is depict expression change?

1120

What is intricate mapping?

1203

Clarify the utilization of aggregator cache record?

1001

What does refresh system mean, and what are its distinctive choice?

1181

Un-Answered Questions { Data Warehouse }

What is the difference between drill through and masterdetail reports?

1162

What is the difference between set functions and filter function in dimensional data?

2910

Explain the difference between rolap and molap?

981

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

904

Write the unconnected lookup syntax?

1084

How to fine tune mappings?

941

What is level based metrics.how will you create it?

877

What are the different methods of loading dimension tables?

993

list out all the transformations which use cache?

1184

What will be the skew for, input file->partition by key-> partition by round robin->output file

969

Differentiate between sas functions and sas procedures.

1242

explain about balanced dimension,

980

Two default user groups created in the repository are____and_____.

2047

where is the cache (lookup, index) created and how can you see it.

2017

-----------With out using DrillThrough how to do Reports?

2047

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