without using linktable, how can i remove the synthetic keys

[#1]

Hi guys,

If I am using linktable I am getting a "out of memory" problem so I dont want to use the Link tables. Without using the Linktable how can I built a datamodel.

DIENSTLEISTUNG:
LOAD DL_ID,
 DL_KURZTXT,
 DL_LANGTEXT,
 DL_ART,
 DL_DVSYSTEM,
 DL_THEMA,
 DL_PRIO,
 DL_ABST_MIT,
 DL_ABST_AM,
 DL_ABST_KURZTXT,
 VER_JAHR,
 VER_LFDNR,
 DL_ANGELEGT_VON,
 DL_ANGELEGT_AM,
 DL_BEMERKUNG,
 DL_KENNZ_LANGTEXT_SS,
 DL_TEXT,
 DL_BEM,
 DL_LETZTE_AEND_VON,
 DL_LETZTE_AEND_AM;
SQL SELECT *
FROM DVG.DIENSTLEISTUNG;

DL_AUFWAND:
LOAD DL_ID &'_'& FIRMA_FB_KUERZEL as DL_ID_FIRMA_FB_KUERZEL_AN,
 //DL_ID &'_'& KA_ID as DL_KA_ID,
 DL_ID,
 KA_ID,
 FIRMA_FB_KUERZEL as DL_AUFTRAGNEHMER_FIRMA_AN,
 DL_AUFWAND_JAHR,
 DL_AUFWAND_MONAT,
 DL_AUFWAND_MENGE,
 DL_AUFWAND_KOSTEN,
 DL_AUFWAND_FIRMA;
SQL SELECT *
FROM DVG.DL_AUFWAND;

DL_KOSTENANTEIL:
LOAD //DL_ID&'_'& KA_ID &'_'& FIRMA_ID as DL_KA_FIRMA_ID,
 //DL_ID&'_'&FIRMA_ID as DL_FIRMA_ID,
 DL_ID,
 KA_ID,
 FIRMA_ID,
 DL_KOSTANT;
SQL SELECT *
FROM DVG.DL_KOSTENANTEIL;


DL_KOSTENKUERZUNG:
LOAD //DL_ID&'_'& KA_ID &'_'& FIRMA_ID as DL_KA_FIRMA_ID,
 //DL_ID&'_'&FIRMA_ID as DL_FIRMA_ID,
 FIRMA_ID,
 KSTKUERZ_JAHR,
 DL_ID,
 KA_ID,
 KSTKUERZ_PROZSATZ,
 KSTKUERZ_BENUTZER,
 KSTKUERZ_TIMESTAMP;
SQL SELECT *
FROM DVG.DL_KOSTENKUERZUNG;


DL_AUFTRAGGEBER:
LOAD //DL_ID&'_'&FIRMA_ID as DL_FIRMA_ID,
 DL_ID ,
 FIRMA_ID ,
 FIRMA_FB_KUERZEL as DL_AUFTRAGGEBER_FB_KUERZEL,
 LEITER_NAME as DL_AUFTRAGGEBER_LEITERNAME;
SQL SELECT *
FROM DVG.DL_AUFTRAGGEBER;

DL_AUFTRAGNEHMER:
LOAD DL_ID&'_'& FIRMA_FB_KUERZEL as DL_ID_FIRMA_FB_KUERZEL_AN,
 DL_ID as DL_AUFTRAGNEHMER_ID,
 FIRMA_ID as DL_AUFTRAGNEHMER_FIRMA_ID,
 FIRMA_FB_KUERZEL as DL_AUFTRAGNEHMER_FIRMAKUERZEL,
 LEITER_NAME as DL_AUFTRAGNEHMER_LEITERNAME,
 VERANTWORTLICH;
SQL SELECT *
FROM DVG.DL_AUFTRAGNEHMER;

[#2]

use join or concatenate()

[#3 · Accepted solution]

You can replace you're concate key with autonumberhash128() function, this will improve the script and reduce the memory use, something like this

autonumberhash128(DL_ID,FIRMA_ID,KA_ID) as _key1,

with this function you can replace all of your sin tables.

Hope it helps

Regards

Enrique

[#4]

I am generating a calendar and then joining all my other tables to this calendar on the basis of date and time from this calendar.

How can i avoid synthetic keys?

Thanks!