Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I am doing full load for the below joining table it's working fine & creating a single table:
XXX_WRITE:LOAD Key,TIMESTAMP(MAX(CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b)) AS MAX_TIMEFROM [lib://VVVXXX/XXXWB.qvd](qvd)GROUP BY Key ;
LEFT JOIN(XXX_WRITE)
LOADKey,CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b AS MAX_TIME,"Feedback",UserFROM [lib://VVVXXX/XXXWB.qvd](qvd);
But When I am doing Partial reload and using below script it is not creating a single table instead it is creating 2 tables with synthetic key.
XXX_WRITE:ADD LOAD Key,TIMESTAMP(MAX(CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b)) AS MAX_TIMEFROM [lib://VVVXXX/XXXWB.qvd](qvd)GROUP BY Key ;
ADD LOADKey,CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b AS MAX_TIME,"Feedback",UserFROM [lib://VVVXXX/XXXWB.qvd](qvd);
How to get a single table after join in case partial reload ?