I have similar problem using TPT in informatica. I am trying to do upsert. UPI is store_number and x_date.
The source have mm/dd/yyyy . i can insert into table but update is not working.
I used update else insert option for upsert. Insterted all rows. I re-ran same file but no rows updating.
We have done upsert for other infromatica for non date key fields.
Please share better way do upsert for matching on date fields from file to table.