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 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: