Aug 28 2014
By default you cannot use the following characters in an lookup sql override : ‘/*’ Because of this you cannot enter SQL Hints. You will get an error message when running your mapping. This is because the informatica parser doesn’t recognize these special characters. To enable SQL hints in a lookup sql override you can …
Aug 24 2011
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 …
Mar 16 2011
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
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 …
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.