on ‎2007 Jun 19 9:21 AM
what is a SID table and what do you mean by deleting master data with SID or without SID ?
Hai Samruddhi,
SID Table acts as link between Dimension table and Master data Table.
i.e for every Dim Id in Dimension table a system generated Surrogate ID will be generated in the SID table which will link this Dimension Table to the respective Master table.
U can find the star schema in the link
http://www.bridgeport.edu/sed/projects/cs597/Fall_2003/vijaykse/extended_star_schema.htm
Deleting Master data with SID will delete the link between Dimension table and master data table.
Deleting Master data with out SID means the SID table will be present but the data will be deleted in the master table.
Regards
Madhavi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.