Reg: How to capture no.of insert,update and delete for a table in TIS
Hi All,
The option of capturing total no.fo records affected in TIS is available. I want to capture how many no.of records inserted, updated and deleted for a particular table through TISEE 3.2.3. Is there any metadata table supported by Talend to capture these statistics information at table level. Also in my designer window I can see no.of records inserted into a table/sec, when I check statistics option while executing a job. How can I capture these information into a table.
Thanks
Najeeb
These global variables can be accessible in next subjob, for example:
tFileInputDelimited--main--tOracleOutpu
|
onsubjobok
|
tJava
on tJava, you can access these global variables to populate the total numbers of inserted/updated/deleted rows.
Shong
