Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Datamart - Beginner and newbie to site

2 posters

Go down

Datamart - Beginner and newbie to site Empty Datamart - Beginner and newbie to site

Post  vijayrc 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

Back to top Go down

Datamart - Beginner and newbie to site Empty Re: Datamart - Beginner and newbie to site

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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