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
.png "sasikanth"){kind=avatar}