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 7345

What r all the reporting procedures...?

3 6889

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 6518

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14266

difference between function and procedure...

IBM,

1 6216

What are the new features of informatica 9 version?

2 8660

What is Relational Integrity?

1 4092

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 17791

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

Deloitte,

3 26302

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18300

Can we have a Mapping without a Source Qualifier?

Deloitte,

14 49831

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

Deloitte,

2 13187

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

TCS,

2 13740

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 5610

How applying "Level Span" in Cognos 8.3?

1 10368

Un-Answered Questions { Data Warehouse }

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4322

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

2145

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3767

Explain what are the possible data marts in retail sales?

1011

What is Linear Regression?

1166

define drill through?

What is data warehosuing hierarchy?

1173

what is degenerated dimension?

3998

Can we create two repositories on same database instance in oracle?

1095

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

What is different between the data warehouse and data mart?

1067

what are the concerns of OLTP and DSS systems?

2450

What are the important features of datastage?

1127

List out some key concept of SAS

1128

Explain the features of connected and unconnected lookup.

935

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