Resolved! How to Avoid Counting Nulls in a DISTINCT Expression
Using DISTINCT() with an IF() in a formula expression leads to incorrect computation as nulls are not handled by default for an on-premise Incorta environment.
Forum Posts
How does Incorta treat duplicate rows for load and update?
If I have a table with keys defined and primary key enforcement turned on how does Incorta ingest and process duplicate rows? First in wins? Last one in wins? Other? If a duplicate(s) is found during an incremental update does the existing Inco...
Incorta SQL table cannot query from Incorta SQL ?
We're getting an error when trying to query a table written via Incorta SQL The actual error is that we can't query a table written in Incorta SQL in the same schema, but we get the same error when querying from a new schema so... maybe the error m...
Max length of internal session variable
Is there a max character length or mac values in a list for internal session variables? We have a large list we are trying to put into a variable and some values are not getting captured despite satisfying all conditions. I am thinking it may be a ...
Sparse Snapshot w/ header and detail tables
So I'm putting together a ( ? ) sparse snapshot table or tables e.g. order header and order lines where I want to capture changes which happen at either the header or the line.Individually I have it, but since header and lines can get independent AsO...
