I have given the run date in the mapping to Column(valid_from_dttm) Expression("&RPT_DTTM."DT). To be frank every thing is fine and loading properly as I required but the issue is creating new RK for closed out records when reopened I need to know why and how to solve it And sorry for late reply Thank you
... View more
Yeah I have used the current indicator also but still it's giving me the same result and I need to know is whether the same RK is picked or not when the closed record is reopened. Thank you
... View more
Day1: suppose I am loading 100 records source and Target contains 100 records Day:2 I am loading empty source of next rundate so all the records in the target are closed Day:now i am loading those all the 100 records of same business id from source so now it is creating new RK(reference key) from 101 to 200 and now here I need to pickup the from old RK only not new as id is same Thanks
... View more
Yes I have given the retain key for account id as business key but it's creating a new RK value of same id for close records when it is reopend
... View more
I am facing some problm with scd type 2 on close out records tht is some records are closed Target table since records are not coming from the source and after few days when the same record come it's creating the new RK value for same record and opening.how can I do this to pick the same RK value of previous, those who knew it please let me know Thanks
... View more
I have a problem with closeout records and as records are closed in Target table since records are not coming from source and when ever the closed record id again coming after few days it is creating the new RK value for same record and it is not picking the same RK value from previous.what can I do for picking same RK and open the record.
... View more