Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fact vs. Dimension table mappings

269019Oct 16 2002

What is the difference between how Dimensions and Facts behave in the Mapping Editor?

I have no problems loading my data into a Dimension, but with the fact table the mapping gets really complex (I have about 5 dimensions and the fact table only contains one measure in addition to the foreign keys).

I'm guessing there is an easy way to map data to a fact table when the dimensions are defined (otherwise I can't see the need to separate dimensions and facts in the mapping editor), anyone who can help me out on this?

thanks,

Ulf

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2002

Added on Oct 16 2002

#data-warehousing, #warehouse-builder

1 comment

377 views