Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Greetings for the day.
I am new to qlikview tech.
I want to know how to do incremental load if i don't have any updated date or modified date to find out new or modified records.
Please suggest me, how to achieve it. Thank you.
With a Key field or a composite (combination of all fields) Key you can achieve similar(upto some extend, i.e not all cases, like: update). See:
Hello Varun,
The solution you chose also depends upon characteristics of the incremental reload.
If the incremental process is a pure append, meaning all the rows loaded prior are preserved and the table will only grow and never edit, this allows certain options like Buffer to be considered in addition to EXISTS or WHERE filters.
If the incremental process involves updating or deleting prior loaded records, or originates from a SQL statement, without dates you most likely have to engage a primary key filter via an EXISTS or WHERE clause.
Even in dupe scenarios, where every field in one row is identical to one or more rows, the differentiator of appending a RecNo() should be enough to give you a consistent Autonumber() that doesn't lose track of even duplicates.
In DB level we can create one field called time field, this will be stamped based on the data load in the db table.
We can use that field in QlikView