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 OLAP?

CitiGroup, TCS,

4 10602

what is information maps?

CitiGroup,

2234

how to intersect the tables by using PROC MIXED?

CitiGroup,

1 8256

Tell me one example for multi valued dimension or bridge table?

Accenture, CMC, IBM, Logica CMG, TCS,

2 19032

Tell me one example for junk dimension?

TCS,

9 45701

what is mean by cognos powerhouse?

TCS,

1 6063

what is an associated query?

2 6080

What is the difference between procedure and stored procedur?

IBM,

2 8331

What is a taget load order?

IBM,

2 8943

what are the perameter and variable?

IBM,

3 8183

Differnce between filter and router?

IBM,

14 41082

what is mean by complex starschema ,star schemagrouping?

1948

What is difference between Business Objects and Hyperion Essbase? Please help me

Cap Gemini, TCS,

1 14756

Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

SAP Labs,

2 5188

who r the users in B.O.XIR2?

PCS,

2 7332

Un-Answered Questions { Data Warehouse }

What are different types of metrics in microstrategy?

972

What is cluster AWS cloud?

Difference between star and snowflake schemas?

1170

What is defined as data mining?

1053

Is there a difference between view filter and report filter?

934

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2139

Explain lookup transformation is active in informatica

1117

What is a bridge table ?

897

What are aggregate transformation?

1048

What is connection profile? : sas-grid-administration

1185

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1595

What is meant by target load plan?

990

What is critical column?

1197

How do you load first and last records into target table?

1169

how to create measures and dimensions?

1139

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