Surrogate Table .It contains DIM ids and SID ids.
They establish link between DIM Table and Mater data , Text & hierarchies.
SID is generated when you load master data.
When master data is loaded then sid's are generated and these sid ids are linked to dimension table which are connected to fact table.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.