http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14310740
For incremental update, I am thinking of having two fact table in Framework Manager model : 1) Data Mart fact table 2) Copy of Data Mart fact table with filter to get only new data
This will require me to have two packages:
1) Pakcage 1 - containing Data Mart fact table and dimensions - this will be used for Full cube update
2) Pakcage 2 - Copy of Data Mart fact table with filter and dimensions - this will be used for incremental cube update
Incremental and full update flow will be :
1. Initial - Full update using package 1
2. Day 1(Monday) - Incremental update using package 2
3. Day 2(Tuesday) - Incremental update using package 2
and so on..
7. Day 6(Saturday) - Full update using package 1
=================================================================================
kay's word:
1. Set Transformer?
2. Change ETL?