Hint on sql override in informatica

Post date: 29-Jul-2010 15:33:37

You can perform SQL overrides in 2 places, at the mapping level

and at the session level. If you do overrides in both places,

the session level will always win over the mapping level. Since

your mapping level override is not being picked up then there

MUST be a session level override that is preventing any changes

made at the mapping level from being picked up when the session

runs.

Edit the session, navigate to the 'Mapping' tab, look for the SQL

Override property and if anything has been done at the session

level, there should be a 'Revert' checkbox visible - click this

box to disable the session level override so the mapping level

override can be picked up. If the 'Revert' button is not

visible, then you should be able to see your hint that you

entered in the mapping appear in this property.