This content has been marked as final. Show 5 replies
In the replicate param file, instead of ASSUMETARGETDEFS you will have to use SOURCEDEFS with a definition file of the source table. You can still use USEDEFAULTS in the COLMAP clause.
No change is required to the extract param file.
Oh ok. Thank you satrap.
Currently, my replicat parameter file looks like below. 8 tables are being replicated using this. But I want SOURCEDEFS as you have suggested only for one table CRTN_HDR_DTL. The rest of the other tables (7 of them) have similair struture in source and Target.
$ cat repudp1.prm replicat REPUDP1 userid GGS_ADMIN_UDP1@brcf, password GGS_ADMIN_UDP1_123 ASSUMETARGETDEFS DISCARDFILE /u05/data/GoldenGate/dirrpt/repudp1.dsc, MEGABYTES 20, append MAP UDP1_GG_TST.PKT_HDR, TARGET SP_UDP1_GG_TGT.PKT_HDR; MAP UDP1_GG_TST.CLS_YLT_DTL, TARGET SP_UDP1_GG_TGT.CLS_YLT_DTL; MAP UDP1_GG_TST.CRTN_HDR_DTL, TARGET SP_UDP1_GG_TGT.CRTN_HDR_DTL; --------------> 3 extra columns only for this table . . .
Mention SOURCEDEFS for the one table and ASSUMETARGETDEFS for the other 2 as1 person found this helpful
userid GGS_ADMIN_UDP1@brcf, password GGS_ADMIN_UDP1_123
DISCARDFILE /u05/data/GoldenGate/dirrpt/repudp1.dsc, MEGABYTES 20, append
SOURCEDEFS <source table definintin file name with path>
MAP UDP1_GG_TST.CRTN_HDR_DTL, TARGET SP_UDP1_GG_TGT.CRTN_HDR_DTL,
COLMAP (USEDEFAULTS) ;
MAP UDP1_GG_TST.PKT_HDR, TARGET SP_UDP1_GG_TGT.PKT_HDR;
MAP UDP1_GG_TST.CLS_YLT_DTL, TARGET SP_UDP1_GG_TGT.CLS_YLT_DTL;
Thank You Satrap.
The parameter file you've provided has worked perfectly.
I have a question on USEDEFAULTS parameter.
The replication worked well with or without COLMAP (USEDEFAULTS) clause .
So, I am just curious if we actually need COLMAP (USEDEFAULTS).
This is what GG reference guide says about USEDEFAULTS
"Automatically maps source and target columns that have the same name
if they were not specified in an explicit column map. "
It may work. But it is good practice to have a COLMAP when you are specifying table names in the MAP.1 person found this helpful