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

Change log deletes

first sorry i posted the same query in the wrong Extractor section.. now i'm putting it in the right one.

Hi,

I'd like to know few things about Change log deletes. I'm looking to get some Change log deletes periodically in process chain i've done the PSA deletes which i understand, would like to know few things there are two scenarios

1. ODS (A) updates further Data targets (ODS) in delta mode, we can cleanup change log if the requests are updated in Data targets, if we do clean up the change log data and for some reason i've to delete the requests from target Data target and have to reinit from the ODS A, can i do full load from ODS A and do a init without Data Transfer will this work even if the requests are deleted from Change log?. When we do full load from ODS A does the data come from Active table or Change log? i hope it is Active.

2. ODS A updates Data Targets but in Full mode: In this case can i just clean up the Change log, whenever we do a full load from ODS A will it affect if the Change log requests are cleaned up completely.

thanks

Mayil

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 03:10 AM

    Full Load is always from Active & Delta is from the change log.

    If you were to load data from ODS to another target with selection conditions,do a Repair Full instead of a Full Load.This would not disturb the subsequent delta.

    Yes,you can clean up change log of the target...Whenever you do a full load data is also loaded into the change log hence should not be a problem unless you want to keep track of the changes in the change log of the target.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.