Question:
hi all!
Do we get value '1' for sid field in sid table.
If NO then why and if YES then why?
Answer:
Then SID = Surrogate ID
- meaning its artifically created Secondary Key -> usually some integer or float
(just ordering number unique locally in data set (i.e. DB table))
- why used? -> in general simplifies implementation of such complicated
structures as cubes in warehouses are
-> quite often Primary Key can be compsed from more columns (i.e composed
infoobjects)
- complicated indexes, complicated referential integrity
-> primary keys of different object data sets can have different primary keys
value domains (integer, characters, ....) and you want to put into domains of
cubes any of those types
SID table of infoobjects then describes the mapping between infoobject key and assigned SurrogateID (secondary simpler technical key)
Domain tables of cubes contains SID values. From Cube definition you know which infoobject was assigned to which domain, so then you can look into proper SID table of that infoobject to find out detail attributes of this particular infoobject when doing detailed reporting.
It's much more complicated inside then I described here, but should show
basic idea of SIDs.
_________________
life only sucks when you let it get that way!