Skip to Content
0
Former Member
Feb 27, 2009 at 02:14 PM

Recordmode and Sort

35 Views

Hi All,

Please help me in the following analysis of the problem:

There are two DSOs 1 and 2.

In the transformation from DSO1 to DSO2, there is a start routine.

The start routine sorts the SOURCEPACKAGE by HeaderGuid,ItemGuid and a key figure which may have value as 1 or 0 in descending order.

So in the change log of DSO1 this Keyfigure will have 1(after image),1- (before image),0 (after and before images) as values.

Then it deletes adjacent duplicates by headerGuid and Itemguid from the SOURCE_PACKAGE[].

My question is :Is this sort correct?

Does this sort identify a difference between 1 and 1- between after and before image?

Also how does the sort distinguish between records having same HeaderGuid,ItemGuid and same Keyfigure as 0?

Suppose the data is as follow:

H2 I2 0

H2 I2 0

H2 I1 1

H2 I1 1-

How will it be sorted and how will the adjacent duplicates be deleted?What will be the result Source_Package[]?