Can anyone help me with the increment load from the database to qlikview. Also i want to know how to do the increment load if there is no date modified column in the source table.
Oh, there is another way to do an incremental "load-new-and-update" load. if the field can only be updated for a known short time after created (say in the same month, or within 10 days of first being created), then you could use an incremental load which would load all the records for the "updateable period" and get the now static records from the qvd (excluding those created within the "updateable period").
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
There are 3 incremental load scenarios (see the reference manual for more information).
If you want to "load-new-only" incremental load, you will need some way of identifying the 'new' records in the source. This could be based on a "created date", or on something like a record ID (assuming that the record IDs increase over time).
If you want a "load-new-and-updated" incremental load, then you need a "date modified" column. Without something like that, this type of incremental load is not practical. If you can write to the database, you could create a stored proc which adds a field to identify the records to load using suitable business logic.
Hope that helps
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Oh, there is another way to do an incremental "load-new-and-update" load. if the field can only be updated for a known short time after created (say in the same month, or within 10 days of first being created), then you could use an incremental load which would load all the records for the "updateable period" and get the now static records from the qvd (excluding those created within the "updateable period").
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
