The SID table (Surrogate ID table) is the interface between master data and the dimension tables;
Advantages :-
a. uses numeric as indexes for faster access
b. master data independent of info cubes
c. language support
d. slowly changing dimension support.
Advantages :-
a. uses numeric as indexes for faster access
b. master data independent of info cubes
c. language support
d. slowly changing dimension support.
No comments:
Post a Comment