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 wrong values in the wrong ports.

Leave a Reply

Your email address will not be published.

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