Five Stars

Another solution to solve this problem ?

Hi The Community !

 

I've a job which purpose is to extract data from a database and to generate a file with these datas.

And as an extra, first and last lines must contain  the numbers of extracted rows.

 

I've done a job which works well (see below) but is there another best solution to do this ?

 

2018-03-29 18_21_36-Talend Open Studio for Data Integration (6.5.1.20180116_1512) _ COIFFIDIS (Conne.png

 

Thanks !

 

JCP

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Thirteen Stars TRF
Thirteen Stars

Re: Another solution to solve this problem ?

Hi,

As you can't get the number of records before the select result, your solution is ok.

Maybe for the last line you should use a tFileRowCount (-1) to get the real nmber of lines in the output file (1rst line = expected number of records - last line = effective number of records).

 

Edit: I replaced "you get" by "you can't get" - of course!


TRF
1 REPLY
Thirteen Stars TRF
Thirteen Stars

Re: Another solution to solve this problem ?

Hi,

As you can't get the number of records before the select result, your solution is ok.

Maybe for the last line you should use a tFileRowCount (-1) to get the real nmber of lines in the output file (1rst line = expected number of records - last line = effective number of records).

 

Edit: I replaced "you get" by "you can't get" - of course!


TRF