on 11-13-2008 5:39 AM
how we handle duplicate records in database?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
can you brief your scenario ?
If you are retrieving data then use SELECT DISTINCT
regards
Gangaprasad
how jdbc adapter receiver send errors to sender system for duplication? if that field have primary key constraint, how this situation handled by jdbc?
then u ACTION = INSERT. then u get an error, when u try to send Duplicate Records for Inserting, then Trigger a Alert for this error.
Check this Discussion
Regards
Seshagiri
how we r generate and trigger alerts for theis error?
Check this link , will be useful for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.