cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SID TABLE

Former Member
0 Likes
5,010

Hi All,

What is a SID table and what it contains?

What is the significance is Surrogate ID (SID)?

How SID is generated?

How it links with Dimension table and Fact table?

Please answer in detail.

Points will b rewarded.

Thank you.

Message was edited by:

Harshal Panchal

View Entire Topic
Former Member
0 Likes

Hi,

Sid Tables are like pointers in C

Look at the Extented Star Schema explained in the Doc

http://www.cundus.de/downloads/CE03_Hahne_slides.pdf