Hi Experts,
My Scenario is FILE TO JDBC:
File -
>DB(has to update 2 DB tables){one for inserting correct data records and the other for inserting error data records}
-
>DB response to update into another table (number of records has been inserted into DB in the above flow)
I have a file to be transfered through PI and store the data into Database.The file has different kinds of rows like header,payment and detail.
Now my requirement is:
1)it should use a control table to store when they ran, records processed, etc.
2)If some rows have wrong information (I.e. invalid number of fields) the entire row(error) should be stored into error tables field.
3)how do i capture number of records that has been inserted into DB and insert into a seperate table.
Could anybody suggest in which way i can proceed to fulfill the requirement.
Thanks in advance for your help.
Regards,
Kalam.