Dear Experts,
I am in the middle of a redesign project to optimize dataflows and to modify them using Transformations and DTP's. We are using the scenario of a Write Optimized DSO (Data Aquisition), a Standard DSO (Corporate Memory) and a Cube (DataMarts).
Currently I am facing the issue that an extractor (0CO_OM_CCA_1) does not provide delta images. Likewise we are forced to use full loads (3 pseudo delta's with selectioncriteria on fiscal year).
In this situation I am unable to use a DSO as Corporate Memory, because the extractor does not provide reverse images (deletions).
I therefore tried to use a Cube as Corporate Memory, because we will be able to delete overlapping requests. At least, I thought...
But in fact, when the dataloads were distributed to the connected datamarts, It is not possible anymore to delete them from the Corporate Memory cube.
So as a result: We cannot use a DSO nor a Cube as Corporate Memory. Does anyone have suggestions about how to handle this situation? Maybe someone came across the same issue?
Every help is welcome and will be <removed by moderator>
Thanks in advance,
Steven Groot
Edited by: Siegfried Szameitat on Feb 18, 2009 4:51 PM