Skip navigation
Contact Us
1107 Views 8 Replies Latest reply: Dec 17, 2012 7:29 AM by Mariappan Kannapiran RSS
Kent Pawar Newbie 4 posts since
May 18, 2012
Currently Being Moderated

Dec 17, 2012 1:50 AM

Why does the Informatica session not proceed with deletion of data?

I have a flat-file source where the first column is used to  flag a record for insert, delete or update. Deletion/Updation is done  based on the PK in the target table.

So we have the records flow from the source into the router where it  gets redirected to a Update strategy transformation - one each for  Insert, update and delete operation.

I have done an update override for the delete and update target instances.

In the workflow, I have set the session properties as follows:

  1. For the target that handles the inserts, I checked 'Insert' in the target's session properties.
  2. For the target that handles the updates, I checked 'Update as Update' in the target's session properties.
  3. For the target that handles the deletion, I checked 'Delete' in the target's session properties.

Now the session works fine when all rows are inserts. But when there  is a single update or delete the session just doesn't proceed after  fetching the source data..

Not sure what is causing such behavior.. Any ideas on how to resolve or further debug this..?

 

 

Thanks.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points