Rollback on load failure ...

[ProDev]

Hi,

Am using INFA 6.2

My Source is Oracle table.
I am inserting records from this table where record_treated_status column for this table is 'Y'.
So, for this purpose I am filter out records from SQ for record_treated_status = 'A' and then, linking to the Target.

Same time I am linking the records from filter transformer to other target in order to make record_treated_status column (of source table) to 'A'.

My problem is, in bwtween such process, if due to some failure the records could not get inserted to Target, then everything should rollback. I mean, no insertion to target as well as the record_treated_status should not be 'A'.

Currently what is happening is few records are geting inserted into the target and the records in source is geting value 'A' for column record_treated_status in few of records.

In summary, either a full insertion should happen making source column as 'A' for all rows OR it should be an entire Rollback on any kind of failure.

Please give me ideas to handle such situatuion .....


Thanks

 

[blom0344]

Simply use a two-step strategy. Write output to an intermediate table. Use contents of this intermediate table to write to the final target in case the first session is succesful. That way you can avoid having to perform a complicated rollback (if at all possible)

In case of failure the intermediate table (use truncate in session) will store zero records. This fact will enable you to use it in handling the outcome of the mapping that writes data to the target......

T. Blom
Information analyst
tbl@shimano-eu.com