Skip to Content
0
Nov 05, 2019 at 02:34 PM

DWF: Strange behavior of RecordMode in NDSO

86 Views Last edit Nov 05, 2019 at 02:35 PM 2 rev

Hi,

I have some issues with delta loading to NDSO. The RecordMode logic works differently than it's described in documents about NDSO, presentations and so on.

I use an example like in default DWF template (DWF 2.0 SP05) which loads data from table to NDSO. First dataset has 4 lines, second dataset has two lines with the same sales order numbers as in the first dataset and RecordMode = 'A'. As I understood examples from documents, RecordMode = 'A' should work like "additive", i.e. add the values from the 2nd dataset to the value in active table. But in my case it works like "After Image" - it overwrites the previous value.

So what is the normal behavior of NDSO in such case? And what may be wrong in my dataflow? Thanks.

1.Initial load

Source data:

Active table after activation:

Change log:

2.Delta load

Inbound table before activation:

Active table after activation:

Change log:

Attachments

001.jpg (69.8 kB)
002.jpg (72.9 kB)
003.jpg (81.4 kB)
004.jpg (95.3 kB)
005.jpg (109.8 kB)
006.jpg (162.6 kB)