You can set the default Target load type for your sessions to ‘Bulk’ or ‘Normal’. This way you do not have to edit them all when the default is set to the wrong value 🙂 To do this open de Workflow manager and click on the Tools menu > Options  and then select Miscellaneous, you …
Tag: Tip
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 …