Make sure that you query the latest mapping version and widget_type = 3 (Source Qualifier). Then select attr_id = 1 and you get the SQL override (if used in the Source Qualifier).
Tag: Informatica Powercenter
Feb 10 2011
Informatica Powercenter : UNION in Lookup SQL Override
A couple of weeks ago I came across something strange when using a SQL Override in a Lookup that contained a Union. For example : SELECT VARCHAR_A VAR , NUMBER_B NUM FROM TABLE_A UNION SELECT VARCHAR_C VAR , NUMBER_D NUM FROM TABLE_B When you use VAR in your lookup condition, Powercenter rewrites the query when it …
- 1
- 2