Page 1 of 1

Constraints for a link

Posted: Mon Dec 13, 2004 5:57 am
by nkln@you
I have given a constarint fro a link and when the job ran , 2 rows went through that link out of 4 rows. Then , when i removed the link, saved the job and ran the job again. Then also only 2 rows went through it, though i removed constraint.



What is the reason for this . How to rectify this.


Thanks in advance.

Posted: Mon Dec 13, 2004 6:20 am
by nkln@you
Sorry, the OS is Windows , but not Unix.

Posted: Mon Dec 13, 2004 6:22 am
by WoMaWil
Difficult to answer without knowing precicely what you do and without knowing precicely how you messure your rownumbers.

Posted: Mon Dec 13, 2004 2:38 pm
by ray.wurlod
Probably your target rejected two of the four rows, maybe due to a primary key unique constraint violation. What do your four rows of data look like?

Posted: Mon Dec 13, 2004 3:03 pm
by ketfos
Hi,
What is the selection creteria and transformations you are using?
Can you give us some sample of data you use?

Ketfos

Posted: Mon Dec 13, 2004 3:59 pm
by vmcburney
Step through it in debug mode from within the Designer, you can watch each row going through. Usually if you lose rows you get warning messages in your job log.