Hello Experts,
I would like to have some tips on incremental fact builds using decision stream.
My requirement is as follows
On daily basis, i will be populating a fact table which will have one date column also.
In the subsequent builds, decision stream should look in the target table to find out what is the maximum date in the date column and populate only those rows where the date in the source data base is greater than the maximum date in the target data mart.
Any hints ?
Thanks in advance
I would like to have some tips on incremental fact builds using decision stream.
My requirement is as follows
On daily basis, i will be populating a fact table which will have one date column also.
In the subsequent builds, decision stream should look in the target table to find out what is the maximum date in the date column and populate only those rows where the date in the source data base is greater than the maximum date in the target data mart.
Any hints ?
Thanks in advance