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?
How to Load Audit Table?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.