Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
we want to implement the Incremental scenario for our project which includes 24 tables of data.
and in total we have some 12 sheets/reports for which we will get the fields from all the tables.
Ex: for reports 1-5 we need first 5 tables , for report 6 we need some 2 tables etc.
Requirement : new records load will be done once in a month , so we can use as date as a parameter to implement this.
and date is Present in separate table.
here my doubt is for which tables I have to write incremental script is it for the fact tables (tables that have fields which are used for measure calculation ) and date table. or for all tables.
Appreciate all your response to this issue.
Regards,
V
Hi vishal,
take a look for this Video, very nice explained:
Incremental Load in Qlikview - YouTube
i hope that helps
beck
HI ,
Inc load is obviously on fact tables and use the date field from fact table itself.
use ETL_LOAD Dates if no other date fields are available in fact table .