Skip to Content

PI receiver JDBC adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 26 at 03:21 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded