This discussion is archived
1 Reply Latest reply: Nov 9, 2010 8:51 AM by User152973 RSS

simple real image replications

802427 Newbie
Currently Being Moderated
Hi friends ,
i wanted to set up simple real image replication using goldengate .please find the details as below .

i have table A with P,Q,R,S,T,U,V columns and Table B with columns S,T,U,V so i want the replication unidirectionsal .whenever on tbale A insert,updates and deletes happens i want same to be replicated on table B .at any point of time A and B should have same data with out duplicate records .Note my table A has constraints and Table B doesnt have any constarints . Please give params for extract and Replicat .

Thanks in Advance

Nancy
  • 1. Re: simple real image replications
    User152973 Newbie
    Currently Being Moderated
    Hi,

    You may try using these parameters.

    on source

    extract ext1
    userid ggs, password welcome
    rmthost localhost, mgrport 7809
    rmttrail ./dirdat/aa, purge
    table USER.A;

    dblogin userid ggs, password welcome
    add trandata user.A, nokey, cols ( S,T,U,V )

    defgen params
    DEFSFILE ./dirsql/1.sql
    USERID ggs, PASSWORD welcome
    table user.A;

    ./defgen paramfile ./dirprm/defgen.prm

    on target

    replicat rep1
    sourcedefs ./dirsql/1.sql
    userid ggs, password welcome
    map user.A, target user.B;


    Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points