Hello Experts
I need few clarifications regarding the concept of DTPs. It will be greatly appreciated if you help me understand this. I tried searching over sdn but my situation seems to be atricky one.
I have a ODS which is loaded every day from billing item and billing header extractors. Now I built a new cube which is supposed to get data from this ODS using a DTP and hence the following concerns:
1) The ODS has been in place for many years and its change log is deleted once every month, so the change log might not contain all the data. Now I want to extract all the data from the ODS to the Cube during the first run of the DTP and then have the deltas flow in the subsequent runs. How should I go about this.
2) Should I create one DTP for full load to extract all the historical data from the active table of the ODS and another DTP for delta to extract the new and changed records from the change log table. Then, how should I synchronize these two DTPs.
This is a critical production issue for me.
Points will be generously assigned.
Thanks
Rishi