Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to Split Dimensions & Facts, while doing Scripting for the Data Model..
consider that, I am having 20 tables i have to do linking..
Can any one explain me with Some Steps or give me some example for that.
Thanks,
Helen
Use transaction table as Fact tables and the master tables as the dimensional tables or use as dimensions. And follow the Star schema or the Snow flake schema for data model.
Or Refer the attached documents for fact creation
For Dimensional modelling
Hi
Attached document might help you.
Regards
ASHFAQ