SID (Master Data)

[Aummad]

Hi,

Please some one explaine me how the SID working with example,

specially if the master data not available,

suppose we load the TD into the ODS and cube without master data,

MS will load through the SID.

Please help me to understand this concept.

Thanks,

[Former Member]

Dear,

1. SID links the Master Data to the DIM tables.

2. Imagine master data is already loaded. Now, when you load the transaction data, it matches with the corresponding key in the master data and creates a SID.

3. Imagine if the master data is loaded afetr the transaction data. In this case, the look up becomes reverse, which means, for every master data that is getting loaded, it needs to scan through the entire transaction data to create SIDs. (This is the reason to load master data first and then load transaction data after that).

4. If no master data is present, then, when the transaction data is loaded, it just creates an entry for the master data in the master data table without any text/attributes and the SIDs are also created(since, master data is not loaded). In this case, if you check the contents of the master data table, you can find that the primary keys are loaded, eventhough the master data is not loaded, but the attributes and texts are not loaded in the master data table.)

Thanks