error handeling in informatca power center
- by user223541
i want to devlop a mapping for followinfg scenerio . I have a 1 source and 1 target and 1 error table.Target and Error tables have all fields that are present in source tables.But the data type o of all fieds for error table are varchar .Error table dont have integirty or foreign key and other constraints .
Error table also have2 more fileds .Error no and error msg.
Now when the workflow is executed if there is erro while inserting any record then that recored shold be moved to error table.Also the data base error code and error message should be logged in error no and error message in error tables fields as mentioned.
How can i devlop such a mappng?Where can i find exaples of such mapping ?