Author's posts
Nov 29 2011
Add color to (Business Objects) Universe object descriptions
Did you know that you can use HTML in the object description field in Business Objects ?? Example : <font color=red>Description: This will show in Red.</font><br> <font color=green>Example: This will show in Green.</font><br> <font color=blue>Source: This will show in Blue.</font> Try other HTML tags in your descriptions, not all HTML works…..
Aug 24 2011
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 …
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