Issue with constraint in Transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
hi_manoj
Participant
Posts: 56
Joined: Sat Aug 13, 2011 2:00 pm
Location: BLR

Issue with constraint in Transformer

Post by hi_manoj »

Hi,

My Target are sequential file. Before target i have a transformer and from Transformer I have 5 out put links (my target files)
Suppose My transformer is T and out put link are A,B,C,D,E. There is a constraint for each out put link.
Out of the 5 constraint 3 are same (say constraint for link A,B,C are same and constraint is x>y) and for the rest two link the constraint is x=y

when i run the job, for link A,B,C records are going in one way say to link A (28,5 rows/sec) where as B ,C (0,0 rows/sec) have no records
but for other two link D and E it is working fine. The number of records to D is equal to E

What can be the issue? Please help me.

Regards
Manoj
Manoj
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Post by jerome_rajan »

Have you by any chance checked the 'Otherwise' checkbox under constraints?
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
hi_manoj
Participant
Posts: 56
Joined: Sat Aug 13, 2011 2:00 pm
Location: BLR

Post by hi_manoj »

No I have not check the Otherwise check box, I have rechecked it and not of the check box is checked for any of the 5 links.

I mean Othewise/Logs is unchecked for all the link
Manoj
hi_manoj
Participant
Posts: 56
Joined: Sat Aug 13, 2011 2:00 pm
Location: BLR

Post by hi_manoj »

Any help Guy's. I have reverse the condition (x>y change to y<x) but no luck.

One more thing I like to share regarding this issue, If i change the order of A,B,C then no data is going to any of the link.

Please help.

Regards
Manoj
Manoj
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You'd have to post your actual constraint derivations before anyone could provide more cogent help.
-craig

"You can never have too many knives" -- Logan Nine Fingers
rhitesh
Participant
Posts: 1
Joined: Fri Feb 22, 2013 5:59 pm

Issue with constraint in Transformer

Post by rhitesh »

If constraints on A, B and C are than why dont you just create 1 link for A only.

After TFM , add copy stage to create pipe line for B and C that way you can still have same resultset for A, B and C
Thanks,

Hitesh
Post Reply