How to Load Audit Table?

pkll · Post by **pkll** » Mon Mar 03, 2014 5:30 am

Hi All,

How to populate the Audit table in data stage. Is there any Routine for that .Each time When the record is rejected I need to increment the count in the audit table along with this i need to calculate Amounts and load into Audit tables?

ray.wurlod · Post by **ray.wurlod** » Mon Mar 03, 2014 3:57 pm

Whatever your data and requirements demand, you design that. There's nothing special about an audit table.

kduke · Post by **kduke** » Mon Mar 03, 2014 5:38 pm

What Ray is saying is that is just like any other table. You load it the same way. If you need the job to do it then you need run a link from the reject link to this table.

If you want a separate job to do this then you need get the row counts to each link and load them to this table or only the reject links. Deciding what is a reject link is not easy. You may need a naming convention to determine that. I have seen people use Src_ for source links and Rej for rejects. Something similar for target links. Targets may need inserts counted separate from updates which means you can no longer use upserts.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2014 7:41 pm

Here are the conventions I prefer to use:

IN = stream source
REF = reference source

OUT = stream output (e.g. to file or Data Set)
INS = inserts
UPD = updates
DEL = deletes
UPS = upserts (rarely used)
REJ = rejects