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 hash partition?

TCS,

3 5171

What is DTM session?

1 9150

How can you define a transformation? What are different types of transformations in Informatica?

TCS,

7 10824

What is mapplet?

1 6431

What is query panel?

1 3844

What is a look up function? What is default transformation for the look up function?

1 5060

What is difference between a connected look up and unconnected look up?

1 6642

What is staging area?

9 17026

What is data merging, data cleansing and sampling?

1 7611

What is up date strategy and what are th options for update strategy?

2 5081

OLAP architecture?

CTS, Honeywell,

1 5948

What is subject area?

2 10460

Why do we use DSS database for OLAP tools?

3 10487

What is ?Data Warehousing??

Accenture,

3 6461

What are Data Marts?

2 5718

Un-Answered Questions { Data Warehouse }

Can you explain surrogate key?

972

Explain fact table?

977

Explain the importance of surrogate key in data warehousing?

1128

What is the difference between a data mart and a data warehouse?

995

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2151

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2077

What is native users?

1102

What is enterprise data warehousing?

988

What are the steps to create a repository in ab initio?

1188

how do you debug and test your sas programs? : Sas programming

1072

What do you understand by term role-playing dimension?

982

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1036

How can we improve session performance in aggregator transformation?

1041

What is a node in teradata? Explain

942

How we can scale Reshift database?

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