Re: goldengate initial direct load table replication order
From: Ls Cheng <exriscer_at_gmail.com>
Date: Mon, 10 Jun 2013 00:29:51 +0200
Message-ID: <CAJ2-Qb_WMKkTpunSCYm5eC3qCoqz3PLJcWDRZo3Ppd8s9sNVWg_at_mail.gmail.com>
Hi Guillermo
My problem is I need to get data from one table first.
Date: Mon, 10 Jun 2013 00:29:51 +0200
Message-ID: <CAJ2-Qb_WMKkTpunSCYm5eC3qCoqz3PLJcWDRZo3Ppd8s9sNVWg_at_mail.gmail.com>
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
Received on Mon Jun 10 2013 - 00:29:51 CEST