Datamart - Beginner and newbie to site

View previous topic View next topic Go down

Datamart - Beginner and newbie to site

Post  vijayrc on Mon Oct 17, 2011 10:42 pm

Hi,
New to Datamart, but have defined the DIM and FACTS.[Simple STAR Schema]
Source is a flatfile and we are planning on using ETL [DS] for basic transformation and load into staging table.
Once staged, do further transformation to load DIM and FACT tables.[granular]
Will do some summarized FACTS based on the user needs.
Then a reporting tool to get the analytics.
Found this site interesting, so registered and thought would interact with the community here.
Some stats: 200+Million rows in FACT/week - to be held for 6 weeks.
Is this a norm in granular FACT table? Just wondering


vijayrc

Posts : 3
Join date : 2011-10-17

View user profile

Back to top Go down

Re: Datamart - Beginner and newbie to site

Post  ngalemmo on Tue Oct 18, 2011 10:05 am

200+ million rows a week is large, but not extraordinary. With the right hardware, it should not be an issue.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum