Hi,
I need to remove duplicate data from the source, only by using transformer stage....Can any one tell me the logic in detail.
Thanks
remove duplicate
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Sat Oct 25, 2008 9:09 pm
- Location: chennai
remove duplicate
priya
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 30
- Joined: Sat Oct 25, 2008 9:09 pm
- Location: chennai
If you tell us what you've tried so far and what has or hasn't worked for you (i.e. convince someone that this is not an interview question) then I'm sure you will get quick assistance. Since someone is going to ask anyway, I will - why must you use only a transform stage? Unless there is a very good reason then one should use a built-in stage, the one that comes to mind is the "remove duplicates stage".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Would you use a crowbar to fasten a rivet? Use the correct tool for the job. In this case the correct tool is either the Remove Duplicates stage or the unique option in a sort.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.