Skip to Content
0

PI receiver JDBC adapter

Apr 12 at 12:34 PM

7

avatar image

Dear All,

I configured the PI interface from CLM to DWH. Here I m using sender file adapter to pick the files from CLM using FCC and update the records in DWH tables using jdbc reciver adapter.

I used action "DELETE" to delete the records and then used action "UPDATE_INSERT" to insert the records if it is new and update if there is existing record but this logic is clearing all the records in the tables and inserting the last record.

Then I used action "DELETE" and action "insert" to meet the requirement to delete teh records before inserting new records in the table but this logic fails when there are duplicate records with same key fields.

Please can you advise why the statement "UPDATE_INSERT" is not inserting records in the table when the table is clear performed by previous action"DELETE"

Thanks,

Ushasri

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers