In Third Normal Form how to apply SCD1 and SCD2 concept
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