system
September 25, 2008, 6:41am
1
HI,
We installed Sales RapidMarts and we are going to install other RapidMarts (AP/AR/GL…etc)
Please let me know how the database will allocate to these modules.
Database share the common dimension tables or Duplicates will create in DB?
please answer this as its very high priority to us.
Thanks in advance
maheedhar (BOB member since 2008-09-25)
system
September 25, 2008, 8:25am
2
The RapidMarts are built so that common dimensions exist just once. You simply install all RapidMarts over the other, common objects will replace the dataflow of the previously installed RapidMart with an identical copy.
Werner Daehn (BOB member since 2004-12-17)
system
September 25, 2008, 8:52am
3
Hi Werner Daehn,
Many thanks for your reply.
I have one more doubt, how the data will store in DB when I’m running the Jobs for each module.
Data will overwrite in common dimension table are duplicate records exists?
Thanks in Advance
maheedhar (BOB member since 2008-09-25)
system
September 25, 2008, 3:34pm
4
Either the dataflow has a Table Comparison or the data gets a full refresh. Either way, you will not have duplicates.
Later, you might want to combine the jobs of the different Rapid Marts into one but not required.
Werner Daehn (BOB member since 2004-12-17)
system
September 26, 2008, 8:11am
5
Thanks Werner Daehn
maheedhar (BOB member since 2008-09-25)