This content has been marked as final. Show 4 replies
Latest means current date(or last day)? The below would be the best practice
I would try this;
I'll go with custom activity table and load based on the change capture to fee latest records based on sr_sra_id (column name might be wrong) and I truncate(from Informatica) this on daily basis.
This would have any point of time latest records.
Edited by: Srini VEERAVALLI on Apr 2, 2013 6:26 AM
You can restrict the other data in RPD itself by setting the flag...
Thanks, Srini & 806756.
@806756, Actually, we are trying to use fragmentation to filter activities fact table by latest flag which will be marked by ETL.
But not sure it is a good way or not.
@Srini, we have a flag to identify the latest activity in our fact table, but can not delete the rest data because we still need them in report.
Any more ideas will be appreciated.
You can create a filter on the Activity logical fact table.. Also you shouldn't be having any performance issues as long as you have a bit map index on "Latest Flag"..