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
Thanks Veeresh Rayan,
I got the right answer. It would be helpful for me.
If you are a new user in OTN,then please be advised that there will be a tag saying correct or helpful for each of the tag.
Please mark that in case any of OTN user answer finds u helpful.
Thanks for your guidance, I need more favour from your side. I'm going to give the session to the clients and users on OBIEE 11g Architecture & Features. for that i need some PPT's for OBIEE 11g. I hope you provide some brief PPT's.
Thanks in Advance,