Dimensional modeling for donations with multiple designations
ttran at 17h08
06
May
2010
Dimensional modeling for donations with multiple designations
I'm trying to find the most appropriate design for the above topic.
Transactional-wise, our system processes incoming donations. Each donation (say, someone walks in and hands you a check) may have 1 or more designations associated with it (e.g., 50% goes to help Haiti, the other 50% goes to help Chile earthquake victims).
One way I thought of is to have a donation_designation_fact table with t
I'm trying to find the most appropriate design for the above topic.
Transactional-wise, our system processes incoming donations. Each donation (say, someone walks in and hands you a check) may have 1 or more designations associated with it (e.g., 50% goes to help Haiti, the other 50% goes to help Chile earthquake victims).
One way I thought of is to have a donation_designation_fact table with t
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1842
- Numbers of messages : 8656
- Numbers of users : 3787
- Numbers of points : 1497
Similar topics
I am trying to put together the bus matrix (to identify the facts tables) for a government correctional agency and am debating between multiple facts for each event in the life cycle of an offender vs. fewer fact tables. I wanted to avoid joining multiple
Trying to figure out how to model this with multiple one to many facts. I'm new to modeling so bear with me if this is simple.
I think a picture speaks a thousand words so here is this:
There's a few dimensions as well but those are easy
Hi
We have Multiple currencies and we need to design our DWH in such a way that user can see his business in his own locale currency and standard currency (USD).
How can i model my DWH to fit multiple currencies please help.
Thanks
$Naren$
Hello,
I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is...
- to calculate the number of records in the
Hi
I'm really stuck on how to model a user need/business need
Basically, we are in the healthcare and we have a software that manage the work
of the paramedics in ambulances. There is a table that store all standard informations about the work
of
Forums from same category
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Search
See also
Informations
2 Replies For the topic :
"Dimensional modeling for donations with multiple designations"
This topic has been viewed 931 times.
Last message :
06/05/2010 at 17h08 by "ttran"
