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]

Hi,

SID stands for "Surrogate ID"

For every Master/Transaction data you load to the cubes, the system automatically generates SID to represent data, because it is easier & faster to process Numeric characters rather than Alpha-numeric.

Even though you may get data for an infoobject by this but you wouldn't get the data for the attributes...

Hope it helps,

Ajay