Could you please let me know how to get error records in runtime and save to DB.
my scenario is: File to JDBC
Requirement: file sender will send csv file to JDBC receiver and save the data to DB tables.
--> i need to save the input file data in to 3 different tables. One for successful records. second db table is for error records.3rd db table is for maintain total number of records inserted in 1st table and 2nd table.
So could you please let me know how to do this scenario...please provide the steps how to do the above scenario.(like MI is sync or async).
configuration i done:
1. DT for file sender and 3DT's for 3 DB tables.
2. MT for file sender and 3DT's for 3 DB tables
3. MI outbound async for file sender,
4. MI for inbound Sync for DB receiver (it will have 3 segments. First segment will have fields to fill successful records(DB table1), second segment is for Error records(DB table2), third segment will have fields like number of records inserted on above 2 tables. )
So please let me know how to achieve the step4. also i need to insert whole error record to single filed of DB table2. and i need to capture error description in to anothe filed of DB table2
can i achieve this in single mapping...or do i need to write UDf's or StoredProcedures...
Best Regards..SARAN