topic How to capture source record count and target record count in Talend Studio

How to capture source record count and target record count

Anonymous — Tue, 30 May 2017 23:35:19 GMT

Hi,

Could you pls let me know how do we capture source record count and target record count in a mapping.

thanks,

Durga Devi

Re: How to capture source record count and target record count

Anonymous — Wed, 31 May 2017 01:57:40 GMT

Hi durga5
Which components are you using in the job? Can you please provide more details about your requirement? So we can give you more accurate answers.

Regards
Shong

Re: How to capture source record count and target record count

Anonymous — Wed, 31 May 2017 19:29:57 GMT

Hi,

I am using tsalesforceinput, tmap, toracleoutput component in one mapping. In this case I want to know how many records were read from the salesforce. and how many records were loaded in the database

In other mapping I use toracleinput, toraclerow(To do deletion/updation based on the criteria), toracleputput component in another mapping. In this case I want to know how many records were read from the database, how many records were deleted/updated, and how many were written to the database.

When I use toraclerow component. there is an option "Use NB_LINE", when I enable this option, is there any extra processing that i need to do

Thanks,

Durga Devi

Re: How to capture source record count and target record count

cterenzi — Wed, 31 May 2017 20:49:14 GMT

The area in the bottom left corner is called the Outline. You should see a list of the components in your job. If you expand a component's entry by clicking on the ">", you'll see a list of the global variables associated with that component that are available to you.

tSalesforceInput should have NB_LINE, and tOracleOutput has NB_LINE_UPDATED, NB_LINE_INSERTED, etc.

According to the tOracleRow documentation, Use NB_LINE "allows you feed the variable with the number of rows inserted/updated/deleted to the next component or subjob. This field only applies if the query entered in Query field is a INSERT, UPDATE or DELETE query." I'm not sure if that means it propagates the value of that variable as the output flow of the component.