Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My question is when loading from resident tables and then transforming data, like in a crosstable script, you will end up with synthetic keys; in order to keep disk space low what is the opnion of developers?
I would like to keep the relationships but remove the syn key what is the best way?
[CT2]:
CROSSTABLE (Field2, Value2,5)
LOAD
[abc123],
[def123],
FirstValue([ID]) as [ID]
RESIDENT [Orion CSV Download]
group
by
[abc123],
[def123],
[ID]
;
If the synthetic key is not causing performance problems then don't remove it. See this discussion: how to remove syn table