capture duplicate
Moderators: chulett, rschirm, roy
capture duplicate
Hi,
I need to capture the duplicate record to the seperate table......only by using transformer stage
Thanks in advance
I need to capture the duplicate record to the seperate table......only by using transformer stage
Thanks in advance
raj
-
- Participant
- Posts: 38
- Joined: Thu Jul 03, 2008 3:42 am
Using sortstage. capture the duplecate records.
Using sortstage. capture the duplecate records.
Thanks
jk
Thanks
jk
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Two points, last one first:nbelwadk wrote:y dont u use remove duplicate stage nd dn a compare stage.
aneways transformer degrades the performance
Transformer performance has not been an issue for quite some time, that was addressed years ago, so your advice while good intentioned is out of date.
Please use a professional level of English here, this isn't your cell phone so take an extra second to spell out your words and check for typos. Not everyone's language of choice here is English, please keep that in mind.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I can't tell from your example what the "duplicates" would be. General advice - sort by the grouping key(s) then check for duplicates using stage variables. First time you see a 'group' is ok, if you see the same one again, not so ok and you should be able to discard or capture them fairly easily via a constraint.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: