DSXchange

Hi

Please can any one help me in this issue, input is a dataset which gets 236615 records and the target should be 50000 records and i am using a transformer stage with @INROWNUM to count the Input records, but what will be the next step to get the 50k records in target.

Thanks

Run the job with the Stop stages after Limit tab option set to 50000 rows. Or add a constraint of @OUTROWNUM <= 50000 to the output link.

Hi

Thanks for your reply, i tried constraint @OUTROWNUM <= 50000 to the output link in transformer stage but the result still show me the same output 236615 reocrds in target and second one - Run the job with the Stop stages after Limit tab option set to 50000 rows, Stop stages after limit tab was disabled and i am not able to use it. please can u give me any other way to get me the 50k output.

Thanks

How many nodes are you using?

Run the job on a single node with the OUTROWNUM <= 50000 option

psssttt... Server job, no nodes.

Check again, the Limit tab is never disabled. Did you select the proper radio button first? And that @OUTROWNUM constraint will work fine as well. Those are your two ways, period.

The Limit tab should be disabled for parallel jobs. The only way you can enforce row limits in parallel jobs is to compile in trace mode, and this puts a Peek stage on every link in the job (so you really NEED a row limit). Parallel jobs are not intended to be limited in production.

Well, if that's the case then we've been mislead.

Hi Guys,
use key generator stage and filter stage

Thanks,
Pathipati