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[]?