How to get the number of rows or records processed on each dataflow

[Former Member]

I can see under monitor window, it does show rumber of rows processed. We have an audit tables on teh backend, woudl like to post those details for each dataflow.

Can someone please kindly provide the details on capturing the number of rows processed.

Thank you very much for the helpful info.

[Former Member]

Hi Guy,

You can enable auditing and insert these values in a custom audit table created.

And at the end we can select and print these details from this audit table in log.

Or

We can get these details from the metadata tables/views.

Eg: alvw_flow_stat,dqvw_reports_stat,dqvw_agr_rptstats

Is that what you are looking for?

Thanks,

Ancy

[Former Member]

Hello Ancy, Thanks a lot for the info.

Could you please tell me how can i pass those record count values into my tab_Jobstatu table insert query.

All i need is for each dataflow it points to a tabl;e, i would to record teh row count, which clearly appears in teh monitor tab,

how can i use these values.

If 100 rows are inserted into a table, then i need to pass 100 as the value, in which DS predefined function will it capture hat value. I want to pass that value into my insert query.

Thank you very much for the helpful info.

[Former Member]

Hi Guy,

Enable the audit option for target as below:

Add the insert query to your audit table in the custom audit rule editor as below:

Let me know if this helped.

Thanks,

Ancy

[Former Member]

You want the record count at the target or at the source? Profiling is one way to find the record count or count the records using a row_gen function. Does that help.