topic Re: [resolved] Load only first 10 records in Talend Studio

[resolved] Load only first 10 records

Anonymous — Sat, 04 Apr 2015 08:24:04 GMT

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.

Re: [resolved] Load only first 10 records

Anonymous — Sat, 04 Apr 2015 17:48:20 GMT

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

Re: [resolved] Load only first 10 records

Anonymous — Mon, 06 Apr 2015 10:29:28 GMT

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

Re: [resolved] Load only first 10 records

Cloudbee — Mon, 06 Apr 2015 21:36:17 GMT

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)

Re: [resolved] Load only first 10 records

Anonymous — Tue, 07 Apr 2015 07:33:29 GMT

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

Re: [resolved] Load only first 10 records

Anonymous — Thu, 09 Apr 2015 06:13:29 GMT

Tank u kiranpariyarath
Thanks&Regards
siva.a

Re: [resolved] Load only first 10 records

Anonymous — Thu, 09 Apr 2015 10:30:12 GMT

u r welcome