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
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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch