DSXchange

Hi All,
I have to create a audit file with the following details in xml format.
filename, file size, number of recs.
how can i know these details without using unix.
is there a way for this or have to do with unix only.

Regards,
Pranay

You can count the lines and total the lengths as the row passes through your ETL design, aggregate these as required and create a new row for each in your audit table. Writing to the audit table impresses as a great opportunity to use a shared container, in which the audit columns such as job name, job start timestamp, etc., can be added.