One way of naming folders in infa: SE_C1_COMMON_SOR – Ingestion area, system of record SE_C3_COMMON_CDW – Warehouse load area SE_C1_[Source Name]_SOR – Ingestion area, system of record for particular source system SE_C3_EDW_[Source Name] – Warehouse load as target from particular source system SE_M_[Source Name] – Data mart load from particular source system via DWH Alternative: […]
Continue ReadingInstallation 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 […]
Continue ReadingPower 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.
Continue ReadingImport 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 […]
Continue ReadingInformatica 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”. 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”
Continue Reading