on 04-27-2011 10:42 AM
Hi Experts,
I need to know the options available in sender JDBC channel to prevent the records to be read twice.
I know that flagging is an option where we use update statement post reading to change the flag to 1.
Kindly let me know all the other options.
For example the database may not have any suitable/free column to update after the table is read.
Thanks,
John
Hi,
As per my knowledge, there are 2 options:
1) Update statement available in Sender channel
2) Use of custom JAVA module, it can help to flag the data as soon as they are read by channel. But this involves the development of such a JAVA module which are extra efforts.
-Supriya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.