Author's posts
Apr 11 2016
How to enable Examine (Diagnostics menu) in Oracle eBS
To be able to use the examine option in Oracle eBS you need to set the following Profile settings : Profile option name : Hide Diagnostics menu entry Value : No Profile option name : Utilities:Diagnostics Value : No After that switch responsibility or logout and login and you will have a new menu item …
Aug 28 2014
Informatica Powercenter : SQL Hints in lookup SQL Override
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 20 2014
Where to find Oracle Business Intelligence Applications (OBIA) Release 11.1.1.8.1 Documentation
You can find the most important OBIA documentation at the following locations : Oracle Business Intelligence Applications (OBIA) Release 11.1.1.8.1 Documentation Library Major topics : Install Guide Configuration Guide ETL Guide Administrator’s Guide Security Guide Release Notes OBIA 11g: Data Lineage Documentation for Oracle Business Intelligence Applications 11.1.1.8.1 BI Applications 11.1.1.8.1 Data Model Reference Guide …
Aug 18 2014
Convert UTC datetime from SQL Server to local timezone (CET) in Oracle.
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
Informatica Powercenter : PMREP Massupdate Commit Type value
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
Informatica Powercenter : Bigint primary key violation
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 …
Sep 11 2012
Where to find Oracle Business Intelligence Applications (OBIA) Release 7.9.6.3 Documentation
You can find the most important OBIA documentation at the following locations : Oracle Business Intelligence Applications (OBIA) Release 7.9.6.3 Documentation Library Major topics : Install Guide Configuration Guide Oracle Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6.2 and 7.9.6.3 Oracle Business Analytics Warehouse Data Model Reference Version 7.9.6.3 Major Topics : Naming conventions …
Jul 23 2012
Add Barcode Font to Business Objects Web Intelligence XI 3.1
Recently I needed to add a barcode on a Business Objects Web Intelligence report. The barcode font was available on de server and client but it was not showing up in Business Objects Web Intelligence. The first option I tried was to create a cell with HTML code to force the font. This worked great but …
Jan 03 2012
Informatica Powercenter Repository : Find which session instances use a certain connection
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 …
- 1
- 2