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 univariate n where it can be used n how...?

2 7492

What r all the reporting procedures...?

3 7059

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 6630

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14494

difference between function and procedure...

IBM,

1 6310

What are the new features of informatica 9 version?

2 8786

What is Relational Integrity?

1 4188

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

3 17942

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 26480

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18494

Can we have a Mapping without a Source Qualifier?

Deloitte,

14 50385

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

Deloitte,

2 13336

what is the use of Java Transformation in Informatica 8.x?

TCS,

2 13906

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 5727

How applying "Level Span" in Cognos 8.3?

1 10446

Un-Answered Questions { Data Warehouse }

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2195

What are stage variables?

1270

What is a data warehousing?

1240

What are the data movement modes in informatica?

1218

Have you worked with/created Parameter file

1716

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1168

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1217

Explain about compound key?

1154

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

1002

What is xml source qualifier transformation in informatica?

1282

What are the different softwares used with their functions in teradata?

1070

List out some key concept of SAS

1223

According to you, what are the most important tables in a dw? Why?

1038

What happens if the owner of an object does not exist in the destination project?

977

hi friends pls forward impropmtu interview question

2171

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