File destination, source, number of rows , columns and other information while processing excel data source using Talend open studio

[Todd66]

i'm converting excel data source to json by taking all data in a file and saved it. now i'm looking for number of records in output file ,number of input , source path of excel file etc.look at it if some body can guide me thanks.

[Todd66]

Extraction of data is the most important step of ETL which involves accessing the data from all the Storage Systems. The storage systems can be the RDBMS, Excel files, XML files, flat files, ISAM (Indexed Sequential Access Method), hierarchical databases (IMS), visual information etc. Being the most vital step, it needs to be designed in such a way that it doesn’t affect the source systems negatively. Extraction process also makes sure that every item’s parameters are distinctively identified irrespective of its source system.

[Anonymous · Accepted solution]

Hello,

tFlowMeterCatcher component will count the no. of records pass by the specify flow.

Please have a look at these documentations about: TalendHelpCenter: tFlowMeterCatcher and TalendHelpCenter: Catching flow metrics from a Job

Best regards

Sabrina