Skip to Content

This document shows how to set an audit point to count the records in source table using Data Services 4.0 SP1

In the data flow, right click and select Audit

/wp-content/uploads/2012/12/1fig_169552.png

Right click on Customer table and select Count

/wp-content/uploads/2012/12/2fig_169730.png

Repeat the same step for target table ALPHA_CUSTOMERS

/wp-content/uploads/2012/12/3fig_169731.png

Now we’ll add an Audit Rule to check that the source and target table counts equal

/wp-content/uploads/2012/12/4fig_169733.png

Close and back to the data flow space

/wp-content/uploads/2012/12/5fig_169734.png

The green check mark means an audit label exists

Execute, and you will change the trace to review the audit

/wp-content/uploads/2012/12/6fig_169735.png

Change the audit trace to YES

/wp-content/uploads/2012/12/7fig_169736.png

You will see AUDIT in the trace log

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply