How to assign recordmode to the NDSO in a flowgraph

[regysm21]

Hi experts,

i am new with HANA DWF so if this question is already answered, please let know the link.

I am running DWF on a HANA2.0 SP 03. I am trying to map a source table to a NDSO. My source table looks like this:

NDSO:

The problem is that I found in the Administration Guide that the RecordMode must be appended manually, in the Data_Target_addRecordNo tile, but I do not find in my mapping such tile. Thus I do not really know, where can I append it. https://help.sap.com/doc/5f67aa7f9a8b491cb08ea4bf9d381d90/2.0.3.0/en-US/DWF_NDSO_Admin_Guide.pdf

Could you please let me know how and where should I append the recordmode in the above flowgraph?

Thanks,

Regys

[Sefan_Linders · Accepted solution]

You have two options. In the first one, your delta should be identified before data enters the inbound queue. That means, the source should provide you with a recordMode like delta-enabled SAP source system extractors do, which you can map 1 on 1 with the recordMode of your inbound queue. Or you get the delta identification in another form and have to convert those values into recordMode values before you map it to the inbound queue. In the second option, you would not have a delta identification provided from the source. Then you have to identify the delta yourself, either by doing a full load to the NDSO and let the activation process figure out what is new, changed or deleted, or by using a table compare of a flowgraph to identify this. The NDSO activation process is likely to be fastest, so I would consider that option first. If you expect deletions, then use the "snapshot" setting of the NDSO.

[Sefan_Linders]

Take a look at the inbound queue projection node, which is the first one after your main source node. Do you see a Recordmode field there?

[regysm21]

Thank you for the response Sefan. I had to remove the Function that was there and assign an 'N' for example. But what I am still wondering is that, what if I have updates or deletes. How can i do a generic recordmode identification?

Thanks a lot,

Regys