This content has been marked as final. Show 4 replies
Dimension is ending with D and dimension staging table ends with DS. Its same nomenclature any one uses in any warehouse projects.
_DS table will directly connect to source and will have most of the detials.
D table will have the Primary Key(Called as ROWWID which will be the foreign key in all the fact table which ot refres too) along with the detials of _DS table.
Mark correct or helpful if it helps,
Edited by: Veeresh Rayan on Jun 5, 2013 4:36 PM