topic [resolved] tflowmeter & tflowmetercatcher - Insert/Update in Talend Studio

[resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Mon, 20 Feb 2017 06:12:55 GMT

Hi,
tflowmeter & tflowmetercatcher catch the number of rows affected after a job is run. How do I differentiate how many rows have been inserted and how many have been updated?
Thanks in advance
Rathi

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Mon, 20 Feb 2017 08:03:10 GMT

Hi,
tFlowMeterCatcher will co unt the no. of records pass by the specify flow.
If you want to count the number of rows are inserted/updated/deleted, we usually use the Nb_LINE g lobal variable in DB component.

when inserted item is choosen, there will be a global variale such as(Integer)globalMap.get("tOracleOutput_NB_LINE_INSERTED"))

will be avaible, which counts the total number of records have been inserted into database. The same to updated, deleted items.

Best regards

Sabrina

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Mon, 20 Feb 2017 09:43:09 GMT

Hi Sabrina,
Thanks for the explanation. My job looks like this mssqlinput --> tmap -- tmysqloutput.
How do I get to use the tmysqloutput_nb_line_inserted & tmysqloutput_nb_line_updated to be stored in the database? I have the tmysqloutput with key enabled and 'Insert and Update' action on table
Please help
Thanks in advance
Rathi

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

avlad — Tue, 21 Feb 2017 04:36:38 GMT

---

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

a_vlad — Tue, 21 Feb 2017 04:40:44 GMT

You just need test it, for example with mysql it both variables will work if You choose "update or insert"
in other case all data will be returned as Inserted

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Tue, 21 Feb 2017 05:54:20 GMT

Hi, thanks for the explanation. I did what you said and could get a hold of number of rows inserted and number of rows updated.
However, I did not use tflowmeter or tflowmetercatcher? How do I incorporate this? Or is it not necessary.
The screen shot of my job is as below
Thanks

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Tue, 21 Feb 2017 07:53:31 GMT

Hi,

If you just want to get inserted and updated rows in processing, the Nb_LINE global variable is enough for you.

The tflowmetercatcher component should catch records processed by each flow.

Best regards

Sabrina

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Tue, 21 Feb 2017 08:01:17 GMT

Ok. So, tflowmetercatcher contains the sum (number_of_rows_inserted + number_of_rows_updated)?

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Tue, 21 Feb 2017 08:16:55 GMT

Hi,
The tFlowMeterCatcher component catches the processing volumetric from the tFlowMeter component and passes them on to the output component. Due to rejected rows by t<DB>Output, s ometimes it is not equal to (number_of_rows_inserted number_of_rows_updated).
Here is the online component reference about: TalendHelpCenter:tFlowMeterCatcher
Best regards
Sabrina

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Tue, 21 Feb 2017 09:52:56 GMT

Thanks Sabrina. I understand now

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Wed, 22 Feb 2017 08:04:28 GMT

Hi,
Can we consider this topic as resolved? Feel free to let us know if there is any further help we can give.
Best regards
Sabrina

Re: [resolved] tflowmeter & tflowmetercatcher - Insert/Update

Anonymous — Wed, 22 Feb 2017 13:35:58 GMT

Sure. Thanks