Skip to Main Content

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!

In Third Normal Form how to apply SCD1 and SCD2 concept

user652652Oct 1 2008 — edited Oct 1 2008
Hi expert

My Datamodel is in third normal form . Means there is no seperate dimension and fact tables. My tables itself contain both dimension data as well as maersure.

for example.

my table sturcture is

Entity : ID f_name l_name exposure_amount Liquidity amount


Here f_name and l_name are dimension and exposure_amount and liquidity_amount are measure.



So can we apply SCD1 and SCD2 concept on dimensions data in this table.

And Please send me the stpes to apply SCD1 and SCD2 concept in OWB. I want to do it from mapping. not from dimension in OWB


Thanks in advance

Regards
Frnds
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2008
Added on Oct 1 2008
3 comments
805 views