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 23742

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 5002

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

CTC,

2 9081

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

2212

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 6760

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 16497

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 6988

tell me the push down optimization

Wipro,

2 5751

tell me the informatica architecture

Banca Sella, Wipro,

1 5669

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

3 6841

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 7613

Shall we connect to the oltp systems directly .,

iNautix,

2 7014

When we are going for Shortcut join and why.

Cap Gemini,

1 5780

Un-Answered Questions { Data Warehouse }

What is a node in Informatica?

1041

What do you understand by user class in cognos?

952

how could you generate test data with no input data? : Sas programming

1187

Define enterprise data warehousing?

1204

What is an olap designer?

967

How complex jobs are implemented in datstage to improve performance?

1042

What are the implications?

1712

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2571

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746

Explain 4gt switch?

898

Difference between nodup and nodupkey options?

1195

Different circumstance which drives informatica server to expel records?

983

what is the purpose of _error_? : Sas programming

1135

How do you promote a non-reusable transformation to reusable transformation?

1138

What are data modeling and data mining? Where it will be used?

989

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