Here is what i am trying to do, I have table from SQL server which a primary key but no Update/Modification DateTime. So I am trying to create a AutoNumberHash128() Key for every record in the Initial load. If a Record is Updated Hashkey will be different and PrimaryKey will be same from the initial load. How do we load only Upadted records into QVD.
(
In SQL
Select * from NewQVD N
Where Not Exists(Select HashKey from IntialLoad I where I.PrimaryKey=N.Primarykey)
)
For New records primary key will be not present in Intial Load.
If some one implemented Incremental Load without Update/Modification Time using Hash key, advice me in right direction.
