PI receiver JDBC adapter

[Usharsree_7999]

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

[adalid · Accepted solution]

Hi Ushasri,

Could you please attach an screenshot of how are you performing all the queries?,

In order to check what the statement is doing please follow below steps:

1.- Open the corresponding Communication Channel in the Integration Builder.
2.- Go to Advanced then in additional parameters stick below parameters:
Name: logSQLStatement
Value: true
3.-Save and activate
4.-Restart communication channel

After above steps have been performed you will be able to see what the SQL statement is executing , you can check this thru Message Display Tool in Audit log tab.

Regards,

Adalid Andrés.