Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

Fact/Dimension - for DW and also DM?

is the Fact/Dimension way of building database only for Data warehouse or Data Mart also has the same concept?

thanks
SOLUTION
Avatar of Marcus Aurelius
Marcus Aurelius
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna

ASKER

>>INMON ......then the DW should be based on these data marts.

what specific methodology?

regardless, in both cases, DW ends up with Facts/Dim?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks dportas

>>I suggest at least Boyce Codd / 5th Normal Form

isn't that the max?

>>My suggestion would be that you consider a Normal Form

so that would be like OLTP method, right?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for clarifying that, dportas.

what is a dependable reference you use for Bill Inmon method of normal form design?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
helped - thanks very much!