errortable validations

[vijayindukuri]

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]

[kcbland]

An exception output link during transformation which sends rows to a file documenting the issues with the data instead of on to the target.

[vijayindukuri]

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

[srinagesh]

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

[vijayindukuri]

Ill try for this and ill let u know about this
thanku
vijay