How to delete DTP Delta initilization ?

[former_member666794]

Hi All,

Can you help me to understand - How to delete delta init ?

Scenario - There are two ODS viz A - Base Level Source is R/3 & B - Transformation Layer ODS which gets supply from ODS A.

A DTP Delta is running from A to B.

Due to some inconsistancy in ODS A, I need to do some correction in ODS A through some full load from source R/3. These full load in ODS A will generate delta for ODS B.

But I donot want to move correction changes ( generated as delta ) from ODS A to ODS B.

As there is already delta running between ODS A to B , to achieve this ( not to move delta generated in ODS A due to repair request to ODS B) I can think of Deletetion of existing Delta init DTP from ODS A to B after full load in ODS A & reinitilization from A to B without data transfer so that Delta pointer should set since last repair request in ODS A.

How can I achieve this ?

Thank you very much in advance.

Regards,

Viresh

[Former Member · Accepted solution]

The initialization of delta with options with/o delta happens at infopackge bringing data from source to PSA.

In case of DTPs only delta flag is set in between two infoproviders or psa-infoprovider.

You can delete the Datamart status in DSO A for all those request which you want to re-load to DSO B.

*Please note, if there are four requests 1, 2, 3 & 4 in manage tab of DSO A, if you delete the data mart status for 3, it will automatically delete the datamart status for above two requests 1 & 2 along with the third one.

*Steps to do so* --

Right Click DSO A --> Manage --> Data Mart status (3rd Col.) +here sign of whereused list shows that delta has been updated to next data target +

In your case as data is loaded from A to B you will find the arrow signs of whereused, next to all the requests which are already updated in DSO B --> Click on the data mart status button -->

delete the request which you want to reload to DSO B .

Once data mart status is deleted you can delete the corresponding requests in DSO B. Once you are done with data correction in DSO A, you can go ahead loading it to DSO A & B, which will automatically be a delta load.

Edited by: Shantanu Goswami on Feb 25, 2010 10:53 AM

[former_member666794]

The quest is answered - I need to load next delta to ODS B without data transfer option which will set data mart for repair request in ODS A without transferring the data to ODS B.

Thank you very much everyone !

Regards,

Viresh

[Former Member]

Hi,

Rightly pointed by Sreekanth There is no such concept of Delta Pointer in DTP.

All you need to do is, load the data to ODS A, then execute with " No Data Transfer, Delta Source in Source Fetched' in DTP loading data to ODS B. This will ensure that the data loaded in ODS A , does not go as a delta to ODS B.

[ssurampally]

Hi,

There is no concept of delta pointer and etc in DTP. the Delta means, if any request in the source is not available in the target means that go as a Delta. In your case just run the delta with "no data transfer" which comes in the execute tab of DTP.

[Pravender]

You already have delta DTP. So after loading data to DSO A, you can reset data mart status on the new request which you do not want to move to DSO B.

For that goto delta DTP, choose update mode 9 : No data transfer; Delta status in source: fetched in "execute tab". It is same as delta init without data transfer.