Skip to Content
author's profile photo Former Member
Former Member

Data Extraction Issue

All,

I have a ODS A from which I have done initialization and I am pulling delta to another ODS B. Now I have a requirement to incorporate a new ODS C whose source is to be ODS A. Is it possible to do an initialization or full load from ODS A to ODS C and then subsequently pull delta to ODS C as already daily delta is happening from ODS A to B. Any suggestions in this regard will be very helpful.

Thanks

Akhila.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 06:46 PM

    Yes.

    Do a full load from A to C. Next, run a delta init (without data) for the same. Next schedule the delta (maybe in the same infopackage as B). That is all you need.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 06:46 PM

    Hi,

    Yes its possible. Do a full load from ODS A to ODS C, so that your data is caught up. Then delete the initialisation from ODS A to ODS B. Do a initialization without data transfer from ODS A to both ODS B and ODS C. Reset the delta. You'll be all set.

    Cheers,

    Kedar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      As Ajay said no need to delete the init. You do a separate init without data transfer into ODS C and use the same info-pack to supply delta to both B and C.

      Thx,

      Soumya