cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Multiple versions of same record in ODQMON causing delta load issue from S/4 to Informatica

neerajnaik
Explorer
0 Likes
153

Hi Experts, seeking your help on below issue/scenario.

Scenario - Data is being pulled into informatica system from S/4 system via CDS view. CDS view is CDC(change data capture) enabled with table elements and view elemenst.

Issue - if a same key combination single record is changed multiple times( say 3 times) between 2 deltas, then ODQMON has 3 version of same data based on timestamp. However, when it moves to Informatica system, all 3 records flow without timestamp. Timestamp isn't part of CDS view as base table doesn't have change timestamp. So, there is no way in Informatica system to identify the latest record. CDS view with CDC enablement has been created on below FICA tables
DFKKKO - has timestamp
DFKKOP 
DFKKOPK
DFKKSUM
DFKKSUMC
DFKKINVDOC_I
DFKKINVDOC_H
DFKKINVBILL_H
DFKKINVBILL_I

Any workaround or any help will be appreciated. Thank You.

 

 

Accepted Solutions (0)

Answers (0)