Tag: Tip

Informatica Powercenter : Default Target load type

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 …

Continue reading

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 …

Continue reading

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