Category: Informatica Powercenter

Informatica Powercenter Source Qualifier with SQL override

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 …

Continue reading

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).

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 …

Continue reading

Load more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close