The override sql
needs to be in the session because of the performance issue. If the sql only in the mapping, when create
the lookup cache, powercenter will include the CHARGE_VAL_TXT in the
order by (sorting). The follow sql in the session will avoid the issue. This override is there to avoid cache.
Subscribe to:
Post Comments (Atom)
1 comment:
nice article post..
http://www.informaticaonlinetraining.co/
Post a Comment