We came across a bug in your code (I think). You have to call the function type_2_scd_upsert with the same data, and you get incorrect behaviour (in my opinion). It is simple to induce. An example is shown below, where INVLDT_LVL_KEYis the primary key:
Hello,
We came across a bug in your code (I think). You have to call the function
type_2_scd_upsertwith the same data, and you get incorrect behaviour (in my opinion). It is simple to induce. An example is shown below, whereINVLDT_LVL_KEYis the primary key:Original dataframe:
Updating dataframe:
After update (bug?):
Desired outcome?
We are using mack 0.2.0.
Thanks for your feedback.