Author's posts
May 03 2019
SSIS Package Protection Level Batch Update
Change protection level in multiple SSIS packages at once. If you are working on packages with multiple developers it is usefull to set the protectionlevel of a project and the packages to Protection Level 2 (Secure sensitive data with password). By default it is set to Level 1 (Secure sensitive data with user key), this …
Feb 16 2017
Informatica Powercenter: How to get current variable value during session run using SetVariable()
During a project I was working on I needed to have a central variable in a mapping that I could set and also retrieve during the session run. There are 4 functions that manipulate mapping variables. When you create a mapping variable you have to choose an aggregation function for this variable, you can choose …
Feb 06 2017
Informatica Powercenter: Remove hash (#) character from header output in a flatfile target
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 …
Mar 14 2016
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
When you encounter the following issue when creating a trigger : Error report – ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [kqlidchg0], [], [], [], [], [], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated 00603. 00000 – …
May 28 2015
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 …
May 21 2015
Informatica Powercenter : Convert String to timestamp with milliseconds
When you want to convert a String to a timestamp with milliseconds and you are only getting zero’s for milliseconds in your database make sure that the following option is disabled in the session (Config Object tab) : If this is enabled the milliseconds will be truncated. You can use the following formula to convert …