Discussion Board for collaboration related to QlikView App Development.
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..
Then it won't be possible to identify changed records. Only new records can be detected.
LOAD ...lot of fields..., hashkey_field FROM HistoricalData.qvd qvd();
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;