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 23911

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

CTC,

2048

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

CTC,

1 5081

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

CTC,

2 9220

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

2266

What is the differnce between SDTM 3.1.2 to 3.1.1 version

Wipro,

5120

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 6838

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 16657

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 7075

tell me the push down optimization

Wipro,

2 5856

tell me the informatica architecture

Banca Sella, Wipro,

1 5756

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

3 6971

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 7729

Shall we connect to the oltp systems directly .,

iNautix,

2 7127

When we are going for Shortcut join and why.

Cap Gemini,

1 5865

Un-Answered Questions { Data Warehouse }

List few etl bugs?

999

Name types of category in which SAS Informats are placed?

1199

what is the difference between microstrategy and cognos?

981

If a variable contains only numbers, can it be a character data type?

1148

What are the different transaction levels available in transaction control transformation?

1280

define cognos reporting tool?

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

984

What is main advantage datawarehousing over oracle?

1044

Differences between connected and unconnected lookup?

1273

What is meant by drill down?

1036

What is teradata? Also, list out some of the primary characteristics of teradata.

1133

What is the use of %include statement?

1108

Explain about scorecarding?

2119

What all are steps in up gradation of Informatica server?

1096

How you can fix the truncated data error in datastage?

1891

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