Does anyone know if it is possible to manually (and elegantly) send row counts to tFlowMeterCatcher?
I am working with the ELT components for Oracle and I dont see any possibilities to collect row count information other than by using the global variables NB_LINE. Is it possible to send NB_LINE directly to tFlowMeterCatcher or eventually via tFlowMeter or how would you do it?
Maybe somehow it is possible to raise the event that triggers tFlowMeterCatcher?
Hi Shong Actually my goal is to put row count information in the tFlowMeterCatcher table. If I have the row count information in e.g. NB_LINE, what is the easiest way to put this information, along with the other informations needed (e.g. user, job id) in the table? Best regards, Lise
Hi kzone Thanks! I wasn't aware of this option. I will definitely use this :-) But when I use ELT component this option is not available. But NB_LINE and NB_LINE_INSERTED is available from e.g. the component tELTOracleOutput. Can this somehow be sent to the tFlowMeterCatcher table (without too much effort)?
Nope that is not possible - the ELT components are special that way. No data actually flows through, all activity is performed by the database. The ELT components are only used to descriebe the metadata, and then Talend generates the SQL statement that is sent to the database. But your suggestion to catch NB_LINE and NB_LINE_INSERTED in a separate subjob would work. I am just not sure how to propagate the infos into a FlowMeter ;-)
Hi Lise As kzone suggested, try this ...tELTOracleMap.... | onsubjobok | tFixedFlowInput--main--tFlowMeter--tLogRow tFlowMeterCatcher--main--insert into DB or File. on tFixedFlowInput, get the value of NB_LINE variable and output it so that it can be monitored by tFlowMeter component. Define one column with Integer/int type, and set its value as: