Informatica PowerCenter Notes
Friday, May 5, 2017
Using lookup input ports in SQL Override for non-cached lookup
If you need to use lookup input ports in the SQL Overrride for non-cached lookup, you need to use ?name? notation, eg.:
SELECT LAST_NAME FROM EMPLOYEES WHERE
EMP_CODE = ?in_emp_code?
1 comment:
Unknown
March 22, 2018 at 8:20 AM
This comment has been removed by a blog administrator.
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
This comment has been removed by a blog administrator.
ReplyDelete