Transaction Commit /Rollback

[ProDev]

How do you accomplish this within Informatica?

1. There's a source table that's used to do the insertion into a destination table. It finds all rows in the source table with PROCESSED_FLG = 'N'.
2. There's a different informatica job that then goes back through the source and destination tables to update the PROCESSED_FLG to Y for the rows processed.

I'd like to have the 1 informatica job that inserts the destination table, will update the flag on the source table while it's processing the data rather than in another job.

The Informatica developers here say there's a problem in that Informatica can't handle errors correctly, for example- say the Insertion to destination fails for some reason.
In that case we don't want to update the PROCESSED_FLG
for that row. Can 2 operations be tied together so that if 1 fails it doesn't perform the other?

Thanks in advance.

 

[raj4Informatica]

Prodev,

You can use post session command to update the flag,that way u will be sure if any error happens in the session the post session command will not run .

HTH

Rajesh