How can I limit the amount of processed rows in a job?

One Star

How can I limit the amount of processed rows in a job?

I know that I can limit the amount of incoming data from the database using LIMIT in the SQL query, but I was thinking if there is a way to set a limit on the amount of successfully processed rows that the job completes?
Community Manager

Re: How can I limit the amount of processed rows in a job?

Hi
Try the tSampleRow component which can be used to choose a list of line numbers.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
One Star

Re: How can I limit the amount of processed rows in a job?

Hi there, 
I am integrating MSSQL to Salesforce. How can I limit the Number of rows to 10 in place of running for a million or so records

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch