I wanted to know how to set the PRE/POST SQL at the target level using informatica mapping SDK ?I am using informatica 8.6.1 SDK (Hot Fix 11)
I am able to set it at the Source Qualifier level but not able to find any API/option for setting at target.
Any help will be appreciated
You can find it in the Mapping. Just open the target entity and click on the properties tab. You have got 6 options there.
1. Reject truncated/Overflowed rows
2. Update Override
3. Table Name Prefix
4. Pre SQL
5. Post SQL
6. Target Table Name
I think you are mainly looking for 4th and 5th option.
You can also set PRE / POST sql options at the session level. Go to session --> right click on it and select edit option.
Select mappings tab and with in the mapping tab you will find target table. Select the target table and go to properties tab, within the properties tab you will find
1. Pre SQL
2. Post SQL.
Here you can set your pre and post sql queries. Setting at session level will not affect your mapping which might be used by other sessions as well.
Thanks & Regards,
Navin Kumar Bolla
Sorry for kicking this very old post up, but really curious.
Did you found a solution for your problem or did you end up doing it manually?