Hi Members,
I have 80 columns coming from the source and in that 5 primary keys , Hana is my target table, my requirement is i have to update the record in the target based on one key column which is unique name, if the record is present in the target it should be updated with the new record coming (SCD Type1), i want only one record on that unique key in the target. I have tried bulk loader options , append and update but it is creating new record in the target if there are any changes in any of the 80 columns. Could you please suggest how to implement SCD 1 on Hana target, if i want to use TC i have to pass 79 Columns on compare columns wont it be a performance issue.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.