Interview Questions Answers in Data Warehouse General

ajay

{ City } vijayawada
< Country > india
* Profession * software engineer
User No # 8368

Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 7
Users Marked my Answers as Wrong # 11

Questions / { ajay }

Questions Answers Category Views Company eMail

Answers / { ajay }

Question { 18532 }

DWH architecture?

Answer

it is composed of dataware house
layer,datastagelayer,process management layer,meta data
layer,application layer and other etc

Is This Answer Correct ?

4 Yes

2 No

Question { 6621 }

What is the capacity of power cube?

Answer

power cube is nothing but it is a file,where we can extract
the data very fastly,and we perform drill up and drill down
operations here

Is This Answer Correct ?

1 Yes

6 No

Question { 7658 }

What is data merging, data cleansing and sampling?

Answer

datacleaning means duplicate data removing,meging means
combing data from sql,oracle and other ets and dumped into
dataware house

Is This Answer Correct ?

2 Yes

0 No

Question { 5132 }

Give me a broad concept of what a data warehouse is, and
what it might be used for?

Answer

it maintains pre historical data

suposse ajay gone to usa yesterday,today he is in india in
normal data base like oracle current information only
availabble such as ajay is in india,but in dataware
house ''ajay gone to usa yesterday,today he is in india''

Is This Answer Correct ?

0 Yes

3 No