Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an one FACT TABLE,
My FACT TABLE don't have the "UNIQUE KEY" and "DATE " fields.
Now I want to do INCREMENTAL LOAD, How can I do that ?
please help me out this issue..
Thanks
Venkey
Then it won't be possible to identify changed records. Only new records can be detected.
MyTable:
LOAD ...lot of fields..., hashkey_field FROM HistoricalData.qvd qvd();
CONCATENATE (MyTable)
LOAD ...lots of fields... , autonumberhash256( ...lots of fields...) as hashkey_field
WHERE NOT Exists( hashkey_field, autonumberhash256( ...lots of fields...) );
SQL SELECT ...lots of fields... FROM MySQLDatabase.MySQLTable;