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

Can we create Hierarchies in generic datasources?

CTS,

2386

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 5738

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 7537

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 6515

What is user docs and how to use this option in bo?

Bank of Baroda,

1 3585

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

Ness Technologies,

2 7423

How can we get two output ports in un-connect transformation?

Ness Technologies,

2 7478

what is the complex transformation you used in informatica

TCS,

2590

permutations of mapplet

TCS,

2513

what is the flat file partition and where have to specify it

TCS,

1 7659

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 5117

Can we call a stored procedure from a unix script which is run using command task

TCS,

1 7096

Can anyone briefly describe abt audit table loading?

TCS,

2 6965

can anyone explain me about retail domain project in informatica?

Zensar,

7950

waht is dataware house

2 4816

Un-Answered Questions { Data Warehouse }

What is clusterservices in obiee ? Why its used?

927

Highlight the need for Performance Tuning.

1113

Where we use surrogate key explain with example?

1139

1935

Can you define bitmap index?

1070

Explain what are slowly changing dimensions?

1028

What is a staging area? What is the purpose of a staging area?

891

What is the dense rank?

1235

Differentiate between operational datastage (ods) and data warehouse?

1183

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1041

What are the functionalities of link partitioner?

1022

How to reverse the string using unix?

3515

Explain proc univariate?

1039

How to join multiple db in catalog?

1019

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1917

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