How to migrate the powerexchange code from one environment to another environment.

Suppose if you want to migrate the PWX code from your Development to QA environment, You need to use a utility called DTLURDMO which is a vendor provided inbuilt utility with pwx. For the oracle tables we normally  add the registrations in the PWX Navigator and respective extraction maps will be created along with the registration maps. Also we set the respective columns as CI (Change Indicators) by manually enabling the option “Amend the Change Indicator” for those columns.

But here is the problem when you migrate the Registration alone, It copy the Registrations to the destination environment but creates the extraction maps newly so again you need to manually enable the option “Amend the Change Indicator” for those columns. So it’s a very tedious task to enable it manually when you are having many registrations. So in order to avoid this you need to copy the Registrations first and then again you will have to copy the extraction maps again. Pls follow the below steps to do that.
  • Put all the registration in a text file (Registration_Copy.txt) in the below format.
USER  ACC_PWX_CDC;
PWD ************;
SOURCE DB_DEV;
TARGETUSER ACC_PWX_CDC;
TARGETPWD *********;
TARGET DB_QA;
Detail;
REG_COPY;
CREATEXMAPS;

SELECT DBTYPE=ORA DBID=DBDV REG_NAME=registration1;
SELECT DBTYPE=ORA DBID=DBDV REG_NAME= registration 2;

RENAME SCHEMA=(Source_Schema, Target__Schema);
MODIFY NEW_DBID=DBQA;
  • Put all the extractions in a text file (Extraction_Copy.txt)in the below format.
USER ACC_PWX_CDC;
PWD **********;
SOURCE DB_DEV;
TARGETUSER ACC_PWX_CDC;
TARGETPWD *********;
TARGET DB_QA;
Detail;

XM_COPY;

SELECT MAP= xtraction1 SCHEMA= pwxsource_schema;
SELECT MAP= xtraction2 SCHEMA= pwxtarget_schema;

RENAME REGTAG=(ORADBDV*,ORADBQA*) SCHEMA=(pwxsource_schema, pwxtarget_schema);

MODIFY NEW_DBID=DBQA;
  • Open your command prompt & go to the PWX installation directory in your local client machine.
cd C:\Informatica\PowerExchange9.6.0
  • Run the below DTLURDMO command on your command prompt to copy the registrations.
DTLURDMO "D:\Personal Documents\PWX_CDC\Registration_Copy.txt".
  • Run the below DTLURDMO command on your command prompt to copy extractions.
DTLURDMO "D:\Personal Documents\PWX_CDC\Extraction_Copy.txt"
 --------------
Error :

150402 125125 WIN32 12368  Unable to save. Registration with same key already  on target database.

Solution :

If you get the below errors when you are migrating the registration from one environment to another target environment. Pls delete the respective registration & extraction from target environment and re-migrate the registration.

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...