DSXchange

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?

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

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.

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