Incremental load

[venkey2847]

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

[Gysbert_Wassenaar]

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;