When using a sql override in a Source Qualifier you have to keep in mind that you have to forward all the ports from your SQ. If you do not forward all the ports Powercenter will alter the query and will change the order of the columns and this will cause it to return the …
Category: Tips
Mar 16 2011
Find SQL Override in Informatica Powercenter Repository
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).
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