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