hi everybody
I am working on BI 7 version.
In our case till now we were using info packages in our data flow.
now client has requested us to prepare data flow in bi7 methodology.
I have doubt in such case how dtp and info package can handle delta functionality.
suppose ODS1 is linked with cube1 and cube2.
ODS1--
CUBE1
ODS1--
CUBE2
cube 1 is getting updated with data IP and cube 2 is geting updated with DTP.
scenario 1
if IP runs first then it will put data mart status on the request loaded in ODS.
now if I run DTP then will it fetch correct data?
I think it should fetch correct data since delta in DTP works based on the last loaded request
scenario 2
if DTP runs first then it will put check mark on data mart, on the request loaded in ODS.
now if I run IP then it will fetch incorrect data(0 records).
since once dtp updates data in cube it will also put check mark on data mart and no data will ne available for info package.
Is It So?
Please correct me if I am wrong.
thanks in advance.