Hi ,
In my current project my source and target database are Redshift db ,While retrieving data its working fine but when I try to load the data into Redshift table using SCD 1 and SCD 2 -upsert logic is not working as expected, the insertion of changed record which is active and updating of existing record to inactive record is not happening. please let me know is this achievable using the option update, else insert if new in alteryx and inserting into redshift db.
or do i need to do any configuration at database end to achieve this.
Regards,
Pushpa
