Re: goldengate initial direct load table replication order

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sun, 9 Jun 2013 15:24:36 -0300
Message-ID: <CAJ2dSGRJ-A_0TPZ7ND=3qvMcBidXxOjgJHX7Vd3Xp-qMXcVOBQ_at_mail.gmail.com>

Have you considered disabling the FKs until the data load is complete? Alan.-

On Sun, Jun 9, 2013 at 2:49 PM, Ls Cheng <exriscer_at_gmail.com> wrote:

> Hi
> Does anyone know if it is possible to force during an goldengate initial
> direct load (I have to do some Transformation so this is the easiest way)
> the order of table to be replicated? I need to replicate the tables in a
> specific order because I am populating a Data Mart dimension tables and I
> need to populate the parent dimensions first bucause the dependant tables
> looks up the parents to populate the FKs.
>
> I have looked all over but cant find any useful information. The only way
> is run the initial load table per table.
>
>
> TIA
>
> --
> LSC
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jun 09 2013 - 20:24:36 CEST