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.
No comments:
Post a Comment