Data Mart Status: Delta load from DSO to multiple Data Targets

[Former Member]

Hi experts,

I have the following scenario:

DSO A --> DSO B

DSO A --> DSO C

DSO A is a common data source, whereas DSO B belongs to me and DSO C to another project.

Now, I need to delta load from DSO A to DSO B and the IT responsible told me that since DSO A has already been delta-loaded to DSO C the day before, and the indicator "Data Mart Status" has already been set.

Therefore I will not get new data records if I run a delta load from DSO A to DSO B. I do not really understand what he means.

However, logically this should be not the case for me!

Could anyone please clear my doubt? Thanks in advance.

Regards

Meng

[Former Member]

You can check it very easily,

Right Click on DSO A --> Manage --> Under Request Column --> Click on Data Mart Symbol which is on Third column "Data Mart Status of the Request". It will show where your data got updated.

It's definatly will DSO B and DSO C.

No need of worry

Regards,

Sushant

[former_member188080]

Yes.

So as long as both the data targets are not updated from DSO A .Its datamart status will not get updated.

Thanks and regards

Kiran

[Former Member]

Hi Joon,

That's not true, you can simply create a new delta DTP between DSO A and DSO B. Once you execute the DTP with required selections and put the execution mode as delta, it will fetch all the data from source and set the new delta pointer for DSO B.

You can have different delta extracted for each target.

Regards,

Durgesh.

[Former Member]

Hi Durgesh,

thanks for your quick reply. We actually have two different DTPs for each of the data target DSO B & C. So basically it means I can trigger a delta load from DSO A to B in this case?

DSO A:

Req 4711

Req 4712

DSO B:

Req 4711

DSO C:

Req 4711

Req 4712

The reason given by the IT responsible was that since DSO C already fetched the delta (Req 4712) from DSO A and therefore DSO B cannot only fetch Req 4712 manually. He meant it is ok if the delta load takes place parallelly via a process chain.

Is this statement true?

Regards,

Meng

[ravi_chandra3]

Hi

I think u have 2 different DTP process for the data target DSO B and DSO C in ur process chain. and u can able to update the delta records to the single DSO B. That is the advantage on DTP in 7.0 but the 3.5 will not fulfill this requirement.

Hope u got it,

Thanx & Regards,

RaviChandra

[Former Member]

Hi Joon,

I would expect that DSO B will extract individual delta from request 4712 as it has loaded delta only till request 4711.

As you have already extracted till request 4711 using delta DTP, if you run the same DTP again it will fetch data from 4711 request onward.

Regards,

Durgesh.