Delta DTP and Open Hub Question

[Former Member]

I am attempting to use a delta DTP to extract data though Open Hub but the DTP is sending out the before and after image of the record. For instance, if I change the value in a field from "DELTA update 1" to "DELTA update 2" this is what the DTP sends out to the Open Hub.

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 1

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 2

How can I get the DTP to send only the last update of a record?

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 2

Thank you for your help.

[sundeep_chalasani]

Hi Wayne,

If you want only the last updated record do a full load from the DTP so you can read from the active table instead of the change log table (Delta). Filtering out from a delta based on the Record mdoe wouldnt be a good BW practice.

So either you truncate the target table and reload everyday or do a full load based on a selection routine (Like a calendar date, billing date, posting date...watever date parameter available to you in the source)

[former_member185181]

check whether the DTP is fetching from active table?

[Former Member]

The DTP is set to use the Active Table (Without Archive).

[Former Member]

Can you just not throw away the record based on the recordmode within the transformation or in the Open Hub BADI?

or is the negative image for a previously loaded cube entry?

[Former Member]

Using the record mode is a good suggestion. The only issue I have with this solution is we pull multiple deltas thoughout the day and if a record is updated and reterived in two or more different deltas then I still have more than one row per unique id. This would be the result if a record was pulled in two different deltas. The X on the end is the recordmode. Those rows would be filtered out.

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 1|X

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 2|

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 3|X

4B28B948B0A9027EE10080000A073203|0000000453|DELTA Update 4|

If I understand your negative image question correctly, it is how the record looked on the previous data activation to the DSO.

I am new to BW so I may be missing something obvious.

Thanks for your suggestions.

Edited by: Wayne Helbling on Mar 2, 2010 5:01 PM