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 10127

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 52195

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

10 20369

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 15085

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

CTS,

6 20500

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 11091

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

CTS,

4 16932

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 7600

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

CTS,

7 17858

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 10126

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 8346

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 5106

difference between xir2 and 6.5 version

4 8958

Un-Answered Questions { Data Warehouse }

What is defined as data mining?

1054

Why do we use link partitioner and link collector in datastage?

1150

What is the surrogate key?

1282

Explain two-tier connection?

957

What does de-partition mean in abinitio?

1297

What Proc glm does?

1098

How do dates work in SAS data?

1192

Can you connect multiload from ab initio?

1238

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1149

Explain about core dimension, balanced dimension, and dirty dimension?

1022

Explain a linked cube?

968

What are the uses of bynets in multi-node systems?

1045

What is staging variable?

1110

which one is better performance wise joiner or look up

1113

Mention few power centre client applications with their basic purpose?

963

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