Informatica - CompareData Warehousing Top-Down approach withBottom-up approach

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 144 of 631

Compare Data Warehousing Top-Down approach with Bottom-up approach

Total Answers and Comments: 7

Last Update: February 12, 2006 Asked by: sarath

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 04, 2005 12:22:13

ravi kumar guturi

RE: in datawarehousing approach(top/down) or (bottom/u...

bottom approach is the best because in 3 tier architecture datatier is the bottom one.

Is this answer useful? Yes | No

October 27, 2005 05:20:24

snrv

Member Since: October 2005 Contribution: 1

RE: in datawarehousing approach(top/down) or (bottom/u...

Top/down approach is better in datawarehousing

Is this answer useful? Yes | No

November 18, 2005 01:37:54

Rajesh.A

RE: in datawarehousing approach(top/down) or (bottom/u...

Rajesh: Bottom/Up approach is better

Is this answer useful? Yes | No

November 19, 2005 08:58:00

vivek barsagadey

RE: in datawarehousing approach(top/down) or (bottom/u...

At the time of software intragartion buttom/up is good but implimentatino time top/down is good.

Is this answer useful? Yes | No

January 20, 2006 04:21:46

sithusithu

Member Since: December 2005 Contribution: 161

RE: Compare Data Warehousing Top-Down approach wi...

top down

ODS-->ETL-->Datawarehouse-->Datamart-->OLAP

Bottom up

ODS-->ETL-->Datamart-->Datawarehouse-->OLAP

Cheers,

Sithu

Is this answer useful? Yes | No

January 29, 2006 12:34:45

gazulas

Member Since: January 2006 Contribution: 17

RE: Compare Data Warehousing Top-Down approach wi...

in top down approch: first we have to build dataware house then we will build data marts. which will need more crossfunctional skills and timetaking process also costly.

in bottom up approach: first we will build data marts then data warehuse. the data mart that is first build will remain as a proff of concept for the others. less time as compared to above and less cost.

Is this answer useful? Yes | No

February 12, 2006 05:37:16

kalam

RE: Compare Data Warehousing Top-Down approach wi...

Nothing wrong with any of these approaches. It all depends on your business requirements and what is in place already at your company. Lot of folks have a hybrid approach. For more info read Kimball vs Inmon..

Is this answer useful? Yes | No

Go To Top