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 washout period?

3 23750

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

CTC,

2005

please anyone explain me the derived table with the problem tables.

CTC,

1 5003

how to solve the incompatible objects and how they are formed actually.

CTC,

2 9089

can we insert all types of charts in a list report? what r the realtime prompts?

2215

What is the differnce between SDTM 3.1.2 to 3.1.1 version

Wipro,

5077

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

Accenture,

1 6763

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 16508

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

Amdocs,

1 6992

tell me the push down optimization

Wipro,

2 5761

tell me the informatica architecture

Banca Sella, Wipro,

1 5672

Hi Experts, Can a single package be shared by multiple users?

3 6851

i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.

Cap Gemini,

2 7620

Shall we connect to the oltp systems directly .,

iNautix,

2 7021

When we are going for Shortcut join and why.

Cap Gemini,

1 5782

Un-Answered Questions { Data Warehouse }

Why do we use exception activity in Datastage?

1318

What is data warehosuing hierarchy?

1175

What is a bridge table ?

891

What is substr function?

1195

What are the different types of reports present in cognos?

988

Why is auto-regression used in forecasting used on cognos platform?

1021

What are the types of containers in datastage?

1193

What are the various methods of getting incremental records or delta records from the source systems?

934

for whom is sas data integration studio designed? : Sas-di

1004

Do you find any difficulty while working with flat files as source and target?

1099

Explain when we use aggregate awareness function in designer?

1028

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

1030

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2388

what is SDLC way of code development?

2044

Explain microstrategy logical primary keys?

1000

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