If you are unable to create a new account, please email support@bspsoftware.com

 

Multiple Data Sources for SCDs - best approach?

Started by c6lapsteel, 12 May 2006 11:47:50 AM

Previous topic - Next topic

c6lapsteel

Hi Everybody,

Let's say we have two sources of Product Information. One is updated daily and contains:

Product Code,
Brand (SCD),
Bulk Code

The other, updated weekly, contains

Product Code,
Batch Size Code (SCD),
Manufacturing Process Code (SCD)

We need to track changes to all fields marked (SCD).

What is the best approach to maintaining one conformed Product Dimension from these multiple sources using DataManager??

Thanks for your ideas,

Opher

You gave no indication of the volume of records or changes per day/week.  Unless the volume is HUGE, I think I would just join both tables in the datastream and let Data Manager process the input as if it were one table.  Not sure what difference it makes that there are two.

Good luck,
Opher

MFGF

Hi,

Assuming you are using a Dimension build for this, then the data coming in would be via a hierarchy.  In this case, as long as your product codes correspond and you have them marked as ID attributes, the products from both data sources should get merged on the level of the hierarchy, and then delivered via your Dim build with the relevant change tracking attributes and a surrogate key.  The key to success, then, is a single Products hierarchy fed from two data sources - one for each table.

Regards,

MF.
Meep!