Tag Archives: goldengate

GoldenGate COLMAP: Map Different Column Name

Prepare Environment * See GoldenGate Tutorial: Simplest to setup environment. Prepare Database Create Source Table  sqlplus gg_src/password — Create src tableCREATE TABLE GG_SRC.GG_TEST_COL1(ID VARCHAR2(20) NOT NULL,NAME VARCHAR2(20), PASS VARCHAR2(512), CONSTRAINT GG_TEST_COL1_PK PRIMARY KEY(ID)ENABLE);  Create Target Table  sqlplus gg_tgt/password — Create target tableCREATE … Continue reading

Posted in goldengate | Tagged , | 1 Comment