Hi Experts,
i am doing proxy to Jdbc scenario. we are getting 20 records form SAP to PI and PI those records to DB. 20 records are unique keys.here we are using if the is record there at db side we are going to update and no records are there at db side we are going to insert record. by achieving this we are using Update_Insert query in action. below is my receiver structure.
statement 0.1
emp details 1.1
action
table
access
field1
field2
key
field3
field4
in sender side we have structure like root node under fields. here my doubt is how we can map.
1. if we mapped root node to root node the action will be executed 20 times or single time.
2. if we mapped sender root node to access elements if the record is there at db side update is executed. at the time update the record or it getting any error.
please help me on this how the update_insert query works at db receiver side. appreciate your help.
Best Regards,
Sanjay.