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:
- For the target that handles the inserts, I checked 'Insert' in the target's session properties.
- For the target that handles the updates, I checked 'Update as Update' in the target's session properties.
- 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..?
in the session config, there's an option 'treat source row as', i think it has to be data driven.
Yup I have set it to Data Driven as we are flag each record as either DD_INSERT, DD_UPDATE, DD_DELETE or just using the router to reject it.
did that resolve the issue ? is there any error in the session log ? maybe you can try using the debugger to see why it's stuck.
Well no.. still stuck. Debugger is disabled as per company policy, guess we don't have the license. I will try another approach now which just requires one update-strategy that will handle the insert, delete and update.
could be an issue with your router, well you can set the trace level to verbose data if debugger is not an option. just scan the log to see what's really passing through the transformation. that's how i manage since my debugger crashed after v9 upgrade
i have one query regarding to normalizer transformation that
How to convert the data like
1 2 3
4 5 6
7 8 9
Output shud be
1 4 7
2 5 8
3 6 9
This should ideally be posted as a new question.. It would be difficult to discuss two unrealted topics within this thread..
Can you tell what is happening instead of deletes/updates..whether the session get s hanged or can u post the session log