Constraints for a link

nkln@you · Post by **nkln@you** » Mon Dec 13, 2004 5:57 am

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.

nkln@you · Post by **nkln@you** » Mon Dec 13, 2004 6:20 am

Sorry, the OS is Windows , but not Unix.

WoMaWil · Post by **WoMaWil** » Mon Dec 13, 2004 6:22 am

Difficult to answer without knowing precicely what you do and without knowing precicely how you messure your rownumbers.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 13, 2004 2:38 pm

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?

ketfos · Post by **ketfos** » Mon Dec 13, 2004 3:03 pm

Hi,
What is the selection creteria and transformations you are using?
Can you give us some sample of data you use?

Ketfos

vmcburney · Post by **vmcburney** » Mon Dec 13, 2004 3:59 pm

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.