[resolved] Load only first 10 records

[Anonymous]

HI
 A small scenario:How to load first 10 records in my target DB. Please let me know how many ways can be solved this problem.
Thanks&Regards
Siva.

[Anonymous]

Hi
Add a sequence number to each records, filter the rows which lesser than 11.
Best regards
Shong

[Anonymous · Accepted solution]

Use tsample row with Range "1..10" and insert into your Desired Database

[Cloudbee]

Hi,
if you mean DB like MySQL I would put the limit to the MySQL query, can't see the point to pull like million rows first and then start limiting them.
Just add "LIMIT 10" to your SQL query.
Peter
The Biggest Talend Components Provider (except Talend)

[Anonymous]

if your input is file then use "limit" option to get 10 rows only. 

[Anonymous]

Tank u kiranpariyarath 
Thanks&Regards
siva.a

[Anonymous]

u r welcome