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 linked cube?

1006

What is a full backup?

961

Do you view contain data?

935

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

What is hybrid slowly changing dimension?

1036

Explain about core dimension,

985

What is data warehouse architecture?

1047

What is degenerate dimension table?

1001

What is dimensional modelling?

985

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

1016

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

1027

What is type 2 version dimension?

974

What is the advantages data mining over traditional approaches?

967

What is surrogate key? Where we use it?

997

For faster process, what we will do with the universe?

992

Un-Answered Questions { Data Warehouse }

What are the processing stages?

1099

To save time, can many reports be run at the same time?

1029

What is the effect of dls on microstrategy?

1005

What can we do to improve the performance of informatica aggregator transformation?

1095

what is microstrategy narrowcast server?

1130

How to create Index to the table in the universe designer and how it improves the Query performence

2553

Define the various join types of joiner transformation?

988

Could any one explain me how to create cascading prompts?

1069

How to generate iqd file from framework manager?

961

What errors and types of errors you faced in Cognos ReportNet?

4188

can anybody mail me the FAQS for hyperion essbase amd planning

5646

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

How would you determine the number of missing or nonmissing values in computations?

1069

what are the errors,warnings in datastage

2698

What is a dw? Why do we need it?

976

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