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 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 …
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.