One Star

[resolved] Load only first 10 records

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.
1 ACCEPTED SOLUTION

Accepted Solutions

Re: [resolved] Load only first 10 records

Use tsample row with Range "1..10" and insert into your Desired Database
6 REPLIES
Community Manager

Re: [resolved] Load only first 10 records

Hi
Add a sequence number to each records, filter the rows which lesser than 11.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

Re: [resolved] Load only first 10 records

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

Re: [resolved] Load only first 10 records

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)
Five Stars

Re: [resolved] Load only first 10 records

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

Re: [resolved] Load only first 10 records

Tank u kiranpariyarath 
Thanks&Regards
siva.a

Re: [resolved] Load only first 10 records

u r welcome Smiley Happy