Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can someone please explain with example on how to do Incremental Load for following scenario. Hope it will be helpful for others as well.
1. PrimaryKey is there in the table but no Time field.
2. No PrimaryKey in the table but there is a Time field.
3. No PrimaryKey and Time field in the table
Thanks,
Attitude
Can anyone have examples of these type of situations?
I also have file having time field but no primary key....
AFAIK, to implement incremental load Primary Key and Timestamp are necessary. In absense of any of them, incremental load can't be implemented in complete(Insert, Update, Delete). However, if it's an 'Append Only' case, can be implemented using a simpler logic.
See this blog post: Qlikview Notes: Incremental Load using Qlikview Components