Limiting rows in parallel job

[swathi Singamareddygari]

Hi all,

I am running a parallel job and i am getting around 22000 rows from source.For testing purpose i want to limit the rows for which the job has to run.

The row limit option ,while runing the job in director is applicable only for server jobs.

can any one please help me in this one.

Thanks &Regards

Swathi S

[nani0907]

In transformer we can give constraints @inrownum<=10 for testing and after remove the constaints once testing is completed.

[sharantheboss]

Hi Swati,

If source is flat file then resctrict records by sampling the records using cat commond.If it is a table edit source query like Fetch first 10 records. we dont ahve any option for PX jobs!.

Regards
BOSS

[DSDexter]

Please re-check. The row limit tab is present for PX jobs also.

[dsusr]

Compile the Job in Trace Mode i.e. go to the Job Properties -- Execution Tab and enable the box Compile in Trace mode. Then you can limit the number of records per link for a partition.

Regards,
dsusr

[edison]

awk -F',' '{if(NR>=9){print $0}}',if it a seq file filter the rows by using command