Skip to Content

How to handle delta by routine or program at transformation level

Hi to all,

Can any one tell me how to handle delta by creating routine or program at transformation level between 2 DSO.

Example: Delta data is moving from DSO1 to DSO2, there is routine at transformation level between DSO1 and DSO2 for lookup of third DSO DSO3.So due to this it may be possible that Delta data get incorrect at DSO2, so to handle this situation, how we will write code for record mode, so only correct delta should go to DSO2.

I shall be thankful to you for this.

Regards

Pavneet Rana

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 04:29 PM

    Hi

    Delta is already managed btw DSO1 and DSO2.

    The fact that you read DSO3 does not have any link to the delta method.

    Why are you reading DSO3 ? is it linked to the data that you have in the delta load ?

    PY

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Pavneet Rana

      Hi

      What are the keys of your DSOs ?

      Do you have key figures in those DSOs ?

      Is the DSO3 updated before DSO1 ? if yes, I do not catch why you have DSO2, you could read data from DSO3 while updating DSO1...

      As for me, fo now, I do not see any incorrect delta..Can you give us the code you have in the TRFN (I guess you are in 7.X dataflow) start routine ?

      PY

      Do you have any key figures in DSO1 and in DSO2 ?

      You should not load from DSO3 to DSO2, but only from DSO1. If you have newer dat in DSO3 you want to load to DSO2, I would go through DSO1...

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 06:22 PM

    As replied by PY no need to handle delta its already taken care of.

    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.