unable to set delta on standard DSO for 0mat_plant_attr ? Only allowing full ?

[former_member182467]

Hi,

We have a requirement to extract material's from 0mat_plant_attr datasource and I have created a new standard dso on top of this DS. I am unable to extract the delta update for this DS. Currently delta load's are scheduled on this DS. Please advise as its taking huge time to extract all the full laod's daily to this DSO and the extraction /dso activation taking long time. Is there any alternative ? ( material/plant is the key in the dso).

thank you

DR

[former_member586947]

Hi Daniel,

     Pls clarify the loading process/data flow of the DSO. Are you loading though infopackgae/DTP?

1. If you are loading through Infopackgae and your data source already running in delta mode then you can not update latest delta request from the data source to DSO. DSO requires a initialization request from this data source.

So, you need to reinitialize the data source and this initialization request has to be loaded to DSO first, then you can run the delta going forward.

2.  If you are loading through DTP then you can load the latest delta requests/all available delta requests from PSA to DSO.

My suggestion is to go with 7.0 data flow and use DTP to load the DSO. So that you need not to worry about the existing data flows connected to the data source and delta reinitialization for this data source again.

Regards,

Satya.

[former_member182467]

Satya

I have not initialized the DSO, I have run the full load on the Infopackage once to get the full load of the mat_plant , then updated that to the DSO, then changed the Infopackage to delta. Later I went to change the DTP of the DSO , from full to delta its not allowing.

Do I try to delete and initialize the DSO laod again to make it delta enabled ?

Thanks

DR

[former_member586947]

Hi Daniel,

    You can try that, but I think 0MAT_PLANT_ATTR will not allow you to create a delta DTP. Some where we have come across the same issue. We have changed our data flow to 3.x.

But what I suggest is, any way you are running delta from data source to PSA (through). Keep only the current delta request in PSA and run the full DTP.

Regards,

Satya

[former_member182467]

But daily the Datasource will be loaded with delta, and if we do daily full load to the DSO, unnecessarily all the data will be loaded to the DSO right. I mean for example if there are 100 delta requests after 100 days and on 101 th day if we are loading the DSO , so all the 100 requests in the PSA will be loaded to the DSO , correct ?

Thanks

DR

[anshu_lilhori]

Keep only the current delta request in PSA and run the full DTP

That is what satya is trying to suggest you.You may delete the previous request from PSA and then load only the new request to DSO.

So at any point of time you will not have more than 1 request loaded in your PSA.

Hope this helps.

Regards,

AL

[former_member586947]

Hi Daniel,

     That is why I told you to keep only one delta request/ possible minimum delta requests(add PSA deletion step in your process chain with retention of 4 or 5 days requests if the data source delta loaded daily once) in the data source.

I don't think so, extraction of 5 delta requests doesn't take much time by the DTP. This is the easy solution to get rid of the current situation.

Regards,

Satya.

[former_member186445]

are you talking about the infopackage, or the DTP?

[former_member182467]

Created a standard DSO on top of 0MAT_PLANT_ATTR ds which has a delta update daily. While setting up the DTP delta on the DSO, its not allowing me. Giving a message only full is allowed.

NOTE: for the first time I have run a full load to extract all the mat_plant data to get a complete load. Is this effecting the change of full to delta on the DTP. I think it should not right ? Please let me know if I am not clear.

Thanks

DR

[RamanKorrapati]

Hi Daniel,

Your data source 0MAT_PLANT_ATTR supports delta?

If yes then DSO can pull delta data/latest request from PSA.

if data source won't supports delta then we need to load full data to DSO.

From DSO to further targets we can introduce delta .

Thanks

[former_member182467]

Yes I have created a full load only for 1 time to get all the mat_plant data, after that want to change the DTP mode as delta ( from full). Yes after doing a full load on the IP, i have changed it to delta, so currently the DS is extracting delta records from ECC. But I am unable to change the DTP to delta.

Thanks

DR

[RamanKorrapati]

Hi,

Assumed as your dso holds one request that full load.

please try this way.

from DSO - Try to delete latest loaded full request.

Now edit your dtp and make it as delta.

Now run your dtp, it will work as full+ init.

means it load all data whatever exist at psa and set delta pointer.

next time onwards it pulls delta data from psa.

Another way:

Try to create new dtp, choose delta mode and at execute tab - processiing mode - No data transfer; delta status in source: fetched

Run your dtp once. it will work as init without data transfer.

at same dtp, change processing mode(in edit) to Serial extraction, immediate parallel processing.

save and activate it.

Once you got delta data to PSA then you can trigger delta dtp.

Thanks

[former_member182467]

Raman,

I tried your 2nd option below without deleting the full load request in the DSO. and it popped the below error message.

[RamanKorrapati]

at ECC side, can you check table ROOSOURCE and see the delta type of your data source.

Based on that we can load data to dso.