hai

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
mah
Participant
Posts: 2
Joined: Sun Jul 08, 2007 12:52 am
Location: chennai

hai

Post by mah »

Hai

How can i remove duplicates using STAGE Variables in Transformer?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Wow - a double whammy. Perhaps one of the least informative subject lines ever used in DSXChange coupled with a posting in the wrong forum.

Try right-mouse click on the stage variable, then choose 'delete'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I don't think the question was about removing stage variables: I think it was about removing duplicates using stage variables. Then again, it could have been about showing understanding in Japanese, who knows? As far as I am aware there are no such things as stage variables in TX.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I figured that with an original question like that in this forum, I could afford to misinterpret his question so that the answer would be easy.
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Try right-mouse click on the stage variable, then choose 'delete'
:lol:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

But just a tad unreasonable for someone with a post count of 1 (at the time).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ray - I missed that that it was the first post.

Mah - I'm sorry sorry about being so harsh, but the FAQs that are recommended reading plus many other posts from members here recommend using descriptive subject lines and posting in the appropriate forums. Plus, the use of the recommended search function would have shown very many threads describing how to do exactly what you are asking about.

p.s. a belated welcome to DSXchange
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Solution:

Make sure records are sorted and partitioned by key field/s for your duplicate checking so that matching rows are adjacent to each other and on the same node in the transformer. Also assign stage variables in right order (Stage variables are processed in order)

svPrev = svCurr
svCurr = input.field
svDupeStatus = If svCurr = svPrev Then 'Y' Else 'N'
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply