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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2008

Added on Oct 1 2008

#data-warehousing, #warehouse-builder

3 comments

808 views