Hello,
Sometimes a picture says is all, but to be complete:
I set my incremental load rule on my datasource to mach any field containing ‘UPMJ’ (INT) with updates and deletes and most importantly: set the “substract from value”-value to 2.
Looking at the picture above this is either not set correctly or not displayed correctly.
Best answer by Christian Hauggaard
Hi
+5Hi
You have clicked Refresh correct?
The fields that do not show -2 (e.g. IXUPMJ) what data type are they? If they are not datetime or integer fields then this might be the reason
You can see this in the Metadata Manager (formerly known as Data Source Explorer)
As shown below I encounter the same behavior for the table Sales.CurrencyFull
I then check my source database and see that the field is text
I then override data type as shown below
Then the incremental load with subtraction is shown
Hello Chrisian,
That seems to be it.
These columns are numeric. The one that did work was overridden to INT, apparently.
Are INTs and DATEs the only permissable kind? Substracting 1 from a numeric field seems like something that should not cause any issues.
+5Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
