cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

File->Xi->JDBC

In above Scenario if the file has two rows their values are identical, then how can we eliminated inserting Duplicate rows into database using JDBC Adapter

0 Likes
View Entire Topic
Former Member
0 Likes

Usage of a custom adapter module at File adapter would greatly help here.

Inside the adapter module to every row add a field <status> and set its value to true or false based on first occurance or repeated value. Inside the mapping map only the records that have the value true for status field.

Regards,

Jai Shankar