Skip to Content
0
Former Member
Nov 20, 2008 at 06:24 PM

DTP and info package in same process chain

89 Views

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--


INFO PACKAGE--


CUBE1

ODS1--


DTP--


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.