Feb 16 2017
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
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 …
May 28 2015
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
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 …
Aug 28 2014
By default you cannot use the following characters in an lookup sql override : ‘/*’ Because of this you cannot enter SQL Hints. You will get an error message when running your mapping. This is because the informatica parser doesn’t recognize these special characters. To enable SQL hints in a lookup sql override you can …
Aug 18 2014
For a project at a customer I had to load data from a SQL SERVER database to a Oracle database. It turned out that the SQL SERVER database stored the date and time data in UTC. This became apparent when the data was reported via Business Objects and all the date time data was off …
Apr 14 2014
If you need to do a mass update of sessions to change the commit type you can use PMREP. This is all explained in the Informatica Help. What is not explained in the help is what value you should enter in the -v option. Here are the values you can enter : 0 – for …
Feb 11 2014
While loading data from a SQL Server database into Oracle i came across a problem. Everytime i did a full load of the data i got a primary key violation in the target table. This was weird because the source did not have any duplicate keys. It turned out to be that the bigint from …
Jan 03 2012
If you want to check if a relational connection is still used in any session instance you can use the following query on the repository: SELECT M.MAPPING_NAME ,SI.INSTANCE_NAME INSTANCE_NAME ,SA.ATTR_VALUE TABLE_OWNER ,MSE.OBJECT_NAME READER_WRITER_TYPE ,C.OBJECT_NAME CONNECTION_NAME ,C.USER_NAME ,WA.ATTR_VALUE SQL_OVERRIDE FROM DWHREP.OPB_SWIDGET_INST SI ,DWHREP.OPB_SWIDGET_ATTR SA ,DWHREP.OPB_MAPPING M ,DWHREP.OPB_WIDGET_INST WI ,DWHREP.OPB_WIDGET_ATTR WA ,DWHREP.OPB_SESS_EXTNS SE ,DWHREP.OPB_MMD_SESS_EXTNS MSE ,DWHREP.OPB_SESS_CNX_REFS SCR …
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.