Synthetic tables when loading from resident tables

[tinkerz1]

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]

;

[Gysbert_Wassenaar]

If the synthetic key is not causing performance problems then don't remove it. See this discussion: how to remove syn table