Below the code example how to get date format as ISO8601. First example is current time zone. Second example is valid if your database is actually in UTC time zone. SELECT to_char(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM') AS ISO8601 FROM dual; SELECT to_char(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SS.FF6"Z"') AS ISO8601_UTC_format FROM dual;
-
-
Direct Links to SPM Incidents, Changes, Problems and Work Orders
Direct links to SPM items Here is a list of hyperlink patterns and bolded text parts to create direct link to SPM (BMC Remedy IT SERVICE MANAGEMENT) items. Sorry, I don’t know which version of the software. Change Request https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=CHG%3AInfrastructure+Change&F1000000076=FormOpen&F303647600=SearchTicketWithQual&F304255610='1000000182'%3D%22CRQ000000243650%22 Incident https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=HPD%3AHelp+Desk&F1000000076=FormOpenNoAppList&F303647600=SearchTicketWithQual&F304255610=%271000000161%27%3D%22INC000001964939%22 Work Order https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=WOI%3AWorkOrder&F1000000076=FormOpenNoAppList&F303647600=SearchTicketWithQual&F304255610=%271000000182%27%3D%22WO0000001757117%22 Problem https://[your domain]/arsys/forms/spm-app-prd/SHR%3ALandingConsole/Default+Administrator+View/?mode=search&F304255500=PBM%3AProblem+Investigation&F1000000076=FormOpenNoAppList&F303647600=SearchTicketWithQual&F304255610=%271000000232%27%3D%22PBI000000050210%22 Direct links to the consoles Incident Management Console https://[domain]/arsys/forms/spm-app-prd/HPD:Incident+Management+Console Change Management Console…
-
Software Development Tools on Windows for ETL Developer
I will share my list of tools and how to setup on Windows 7. This page is under constant change and reformatting. Table of Contents UtilitiesWindows UtilitiesFontsEditorsScriptingCygWinContext menu enhancersInformatica Power Center Client ToolsCustomizations Utilities Windows Utilities Windows environment variable editor Rapid Environment Editor portable Windows uninstaller Revo Uninstaller Portable Archiver 7-Zip FAR Manager Total Commander Host File Editor Free Download…
-
Informatica Workflow is not Getting Scheduled
I just learned small detail, that even if you define a schedule in the Informatica Power Center Designer, it is not scheduled. You can check scheduling status in the Informatica Power Center Workflow Monitor. See – the status is empty. And the worfklow schedule is defined as well. The solution is that the workflow does not have Integration Service assigned.…
-
ERwin How to Set Owner (Schema Prefix in Oracle Database)
Three options to get schema prefix in DDL SQL scripts generated in ERwin. 1. Global Setting Erwin main menu Model -> Model Properties -> Set Default Owners… 2. Local Override in the Model Open Physical view in the model Right click on the table “Table Properties…” to open Oracle Table Editor. There is a column “Owner”. Press F2 and type…
-
Installation of Power Exchange Client Tools
Client Exchange Navigator and plugins for Power Center Designer to import DB2 sources. Prerequisites You must and user account on the mainframe. Close all Informatica Power Center client tools: Designer, Workflow Manager and etc. Installation Download setup from defined location and extract to your location. Run as Administrator install.bat Click Next Enter licence. Get it from your colleague. Accept default path.…
-
Installation of Data Integration Hub Client Plug-in for Power Center 10.1
This post describes how to install Data Integration Hub client plug-in for Power Center Designer version 10.1. After installation you will be able to create custom mappings and manipulate Data Integration Hub processes by using Data Integration Hub API. Version of Power Center Client Tools and Data IntegrationHub (DIH) must match. In my case both Data Integration Hub Power Center Client…
-
Power Exchange Documentation from Informatica
Apparently Power Exchange help topics in the Power Center library and in the Power Exchange Navigator library are different. Below images prove that and you need to read both sources to learn Power Exchange better.
-
Import from Power Exchange source error
You have successfully installed Power Center Client tools and Power Exchange Navigator, but still receive below error. You get it when you choose Import from Power Exchange source in the Mapping Designer. Try to fully restart your computer. It helped me. Designer Error occurred loading library [dtIscIi32.dII]. System error encountered is 126. Error text is The specified module could not…
-
Informatica Power Center Server Licence Does Not Allow Self-Training Installs
Question: I was looking for answer to this scenario: Can I install Informatica Server (power center server) on my machine in the virtual box for my personal training or prototyping purposes? If it’s allowed, can I use existing XXX Company license key? Answer from Informatica: Hello, unfortunately, this is not possible.
