Tag: Informatica

Informatica Powercenter: Remove hash (#) character from header output in a flatfile target

hash character

When you have a flatfile as a target for your ETL Powercenter prefixes the header of the file with a hash (#) character when you choose to have Powercenter generate the header from the target definition port names. Usually you do not want this hash to be present in your file. The easiest way to …

Continue reading

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

Extend Informatica Powercenter Designer workspace

Did you ever run into the problem that your workspace is not expanding and your mapping doesn’t fit ? Try setting the zoom level to 100% and drag a transformation to the edge of the workspace. Your workspace will extend. This is probably a bug in version 9.1.0 Hotfix 4

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