Category Archives: Informatica

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.

Workflow scheduling status in the Workflow Monitor

Workflow scheduling status empty in the Workflow Monitor

And the worfklow schedule is defined as well.

Workflow schedule defined in Workflow Designer

Workflow schedule defined in Workflow Designer

The solution is that the workflow does not have Integration Service assigned. Once the service is assigned, it becomes Scheduled.

Assign Integration Service to the workflow

Assign Integration Service to the workflow

Now the status is correct – Scheduled

Workflow scheduling status in the Workflow Monitor

Workflow scheduling status “Scheduled” in the Workflow Monitor

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. Click Next.

Review installation summary. Click Install.

Wait for installation complete. Click Done.

Restart Windows.

After restart, configure file dbmover.cfg file in these locations:

  • “C:\Informatica\PowerExchange10.1.0”
  • “C:\Informatica\PowerExchange10.1.0\bin32”

Verify if you can import Power Exchange source in the Designer.

Documentation

 

Power Exchange Documentation from Informatica

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 10.1.0

All Power Center client tools must be closed. Even better restart PC before installation.

In general these steps need to be completed:

  1. Installation of DIH client tool using DIH setup 10.1
  2. Downloading the patch from Informatica
  3. Fixing Informatica patch
  4. Registering the plug-ins

Installation of DcIH client tool using DIH setup 10.1

Installation screens are at the bottom of the post. Main screen is this one to enable only one option for plug-in.

Downloading the patch from Informatica

After installation Power Center Designer might crash as described here PowerCenter Designer Client crashes while opening mapping having DIH/DX transformation in PowerCenter 10.1

Download the patch and unzip the patch to DIH installtion directory. In my case to “C:\Informatica\DIH\DataIntegrationHub\powercenter”. Now it looks like this

Open the folder plugin101 and edit the file “DXPluginWow6432Node.reg” with text editor. As I’m using Informatica and DIH version 10.1, I have to edit last line in the file by adding the path to folder “plugin101”. Don’t forget double slash in the path

Before change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”$DX_HOME$\\powercenter\\plugin100\\DXPlugin.dll”

After change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”C:\\Informatica\\DIH\\DataIntegrationHub\\powercenter\\plugin100\\DXPlugin.dll”

Fixing Informatica patch

I think even the patch has a bug left, so you need to update the version number in the path to point to correct folder holding DLL file. Instead of pointing to version 10.0, we change it to 10.1

Before
change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”C:\\Informatica\\DIH\\DataIntegrationHub\\powercenter\\plugin100\\DXPlugin.dll”

After
change [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Informatica\PowerMart Client Tools\10.1.0\Plugins\Informatica]
“DX”=”C:\\Informatica\\DIH\\DataIntegrationHub\\powercenter\\plugin101\\DXPlugin.dll”

Registering the plug-ins

After finished editing the Windows registry file, double click on it to add entries to Windows registry and register DIH extensions with Power Center Mapping Designer. Click Yes and OK. More relevant information at How To: Register DataExchange/Data Integration Hub plugin in powercenter?

Start Power Center Designer and you will see Advanced Transformation Toolbar with new DIH transformations. However they will be disabled.

Open repository used by Data Integration Hub and open mapping designer. The transformations become active. Otherwise transformations will be disabled in “regular” Power Center Repository.

Transformations added to the mapping designer canvas.

Installation Screens

 

 

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.

Power Center library contents for Power Exchange

Power Center library contents for Power Exchange

Power Exchange Navigator library

Power Exchange Navigator library

 

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 be found.

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.

 

Informatica PowerExchange 9 Uninstall Error

Before migrating Informatica client tools to Informatica 10, I had to uninstall version 9. On starting the uninstaller, I got immediately this error in Windows 7: “Windows error 2 occurred while loading the Java VM”.

Windows error 2 occurred while loading the Java VM

Windows error 2 occurred while loading the Java VM

To run uninstaller, run this command from command line with Administrator privileges

C:\Informatica\PowerExchange9.5.1\Uninstaller_pwx\Uninstaller.exe LAX_VM "C:\Program Files (x86)\Java\jre1.8.0_101\bin\java.exe"