Incremental load

venkey2847 — Thu, 01 Sep 2016 12:09:32 GMT

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

Re: Incremental load

Gysbert_Wassenaar — Fri, 02 Sep 2016 09:02:47 GMT

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;