Re: goldengate initial direct load table replication order

From: Bobby Curtis <curtisbl_at_gmail.com>
Date: Sun, 9 Jun 2013 19:53:53 -0400
Message-Id: <561ACCC3-526D-4678-80BA-10C28CE098F8_at_gmail.com>



LSC, Is this an initial load of the target database?

Normally, the table/map statement in the parameter files would direct the load process on what table is first. After that, the tables should be loaded according to transaction as it comes into the target database. FK shouldn't be a big issue either way.

Thanks

Bobby

On Jun 9, 2013, at 6:29 PM, Ls Cheng <exriscer_at_gmail.com> wrote:

> Hi Guillermo
> My problem is I need to get data from one table first.
>
> For example table t1 and t2, in order to fill t2 table I need to fill t1
> with surrogate keys with a sequence, this will be t2 FK so if I dont load
> t1 first I cant load t2. This is not Replication from production to a
> Reproting site, it production to populate Data Mart Dimensions and these
> dimensions has production table structure + surrogate key.
>
> Thanks
>
> --
> LSC
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 10 2013 - 01:53:53 CEST

Original text of this message