Hi
I have an error table in which i need to popultae the error data which is being rejected when any error occurs.
for Example if we are processing a record for sales, a field values triggers a Range error, the following will occur:
1) the error record will NOT GET INSERTED INTO THE SALES TABLE
2)a record will get inserted into the E_SALES TABLE with the following data
ERROR_SID ERR_DATA_VAL_LIST
these are attributes of my error table E_SALES
For this i need to write a condition so that the rejected data will go to the
error table Can any one help me in population the error table by using a condition
thanku
[/code]
errortable validations
Moderators: chulett, rschirm, roy
An exception output link during transformation which sends rows to a file documenting the issues with the data instead of on to the target.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 66
- Joined: Fri Nov 25, 2005 7:55 am
thats ok thankyou kcbland
kcbland wrote:An exception output link during transformation which sends rows to a file documenting the issues with the data instead of on to the target.
Can u just explain me how the process goes since i had done the same and what conditon must be given for that.
thanku vijay indukuri
Code: Select all
SrcLink TargetLink
Source ---------------------> Transformation ---------------------->Target
|
| ErrorLink
V
Error Table
in the constraint on the ErrorLink you can either use
TargetLink.Rejected or (SrcLink.Rangevalue < Minrange or SrcLink.RangeValue > MaxRange)
or TargetLink.Dbmscode <> ""
This will load send the records from source which are either rejected at the target or which have values outside the range, to the ErrorLink.
You can use "If" statements in the derivation part of the Error_Message to populate the Error Table.
Hope this helps
-
- Participant
- Posts: 66
- Joined: Fri Nov 25, 2005 7:55 am
Thankyou srinagesh
Ill try for this and ill let u know about this
thanku
vijay
thanku
vijay