Using Data Definition File SOURCEDEF in GoldenGate or DEFGEN Utility

Source Definition in GoldenGate is used when we have different table structure on source and target database or databases are different.

Please find the steps to generate Goldengate source definition file using defgen utility and use it on target to get source table definition

Step 1:- Go to GGSCI prompt and create the defgen parameter file


GGSCI (Hostname) 1> edit params defgen

defsfile ./dirsql/SOURCE_DEFINITION.def
userid ggowner password *******
TABLE SOURCE_SCHEMA.*;

Step 2:- Invoke the DEFEGN utility from GoldeGate home location

$./defgen paramfile ./dirprm/defgen.prm

Step 3:- Use the SCP or FTP to copy the definition file SOURCE_DEFINITION.def from source to target server

Step 4:- Specify the copied source definition file SOURCE_DEFINITION.def on the replicat parameter file in target database

SOURCEDEFS ./dirsql/SOURCE_DEFINITION.def