Setup: I need to union two Incorta tables. I also need to add formula columns so not an Incorta SQL derived table. This *has* to be done in Incorta because half of the UNION is an Incorta snapshot table the contents of which do not persist in the...
I have two "fact" tables ( one is actually a snapshot table so I'm not trying to get measures from it so much as I'm trying to get point in time attributes from it ) both joined to a date and a customer table where the "fact" is the child.In DW term...
[edit: Of course, as soon as I hit "post" I remembered the Inspector Tool and the InspectorMetadata schema -- leaving this here to curb my hubris and as a quick answer if anyone else searches for this topic.] I could have sworn I saw an article on ...
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...
