Analytics 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!

Unable to get the updated rows in scd type3?

ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTDAug 31 2015 — edited Sep 1 2015

Hi,

I am trying to implement the scd type3.

For this, i have used ikm sql incremental update & ckm oracle.

I have opened ikm & duplicate the update existing rows command. i have changed query. and

also mapping source to target table , i have changed ud keys. i hav eupdated smith sal 800 to 30000 after execution, i got current sal value & i didnot get previous data salary.

through this link, i am impleneting scd 3

http://www.odigurus.com/2012/01/scd-type-3.html

SCD Type3 in ODIDW Team

still i did not get previous data.

Please help me.

thanks in advance,

a.kavya