Thursday, 20 June 2013

What is a SID table and advantages. | SAP BW INterview Questions

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.

No comments: