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

Explain the functionality of your current project?

IBM, Miles Software,

1 10124

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 52187

What is Molap and Rolap? What is Diff between Them?

10 20367

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

TCS, Wipro,

4 15082

how do u use sequence created in oracle in informatica? Explain with an simple example

CTS,

6 20492

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

CTS,

4 11089

can v update d records in target using update stargey without generationg primary key ? explain

CTS,

4 16929

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

Wipro,

1 7598

hw cn v elimate dublicate values from lookup without overriding sql?

CTS,

7 17852

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

ASD Lab, Wipro,

2169

difference between stop and abort

2 10125

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 8345

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

Wipro,

2 7495

how to coneect to a server in a business objects

1 5104

difference between xir2 and 6.5 version

4 8956

Un-Answered Questions { Data Warehouse }

how would u estimate the size of Aggregator transform data and index cache?

1976

Tell e how how dealt with..

2237

Explain joiner transformation in informatica

1139

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2201

Define query items?

1026

How to deploy from one server to another server?

2510

What is the difference between Datastage 7.5 and 7.0?

1113

what is online view?

1950

Explain direct and indirect flat file loading (source file type) - informatica

1331

What is fact? What are the types of facts?

1132

What according to you are the roles and responsibilities of a microstrategy developer?.

1026

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1098

When can we choose the Redshift ?

how to delete one row in target dataset

3130

Explain the methods to improve performance of a graph?

1119

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