I’ve had difficult time to find “vanilla” list of directories, so storing here as a reference. Informatica PowerCenter 10.0.
Informatica PowerCenter 10 default list of directories in infa_shared
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 empty in the Workflow Monitor
And the worfklow schedule is defined as well.
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
Now the status is correct – Scheduled
Workflow scheduling status “Scheduled” in the Workflow Monitor
Client Exchange Navigator and plugins for Power Center Designer to import DB2 sources.
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:
Verify if you can import Power Exchange source in the Designer.
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:
Installation screens are at the bottom of the post. Main screen is this one to enable only one option for plug-in.
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”
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”
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.
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 Exchange Navigator library
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.
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.
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
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"