cancel
Showing results for 
Search instead for 
Did you mean: 

ODS table for delta upload

Former Member
0 Kudos

I have created a custom ODS which contains all the Material Movement records(MSEG). i need full as well delta load from the ODS.

Please let me know which ODS table(Active or Changed Log) is used for full and which ODS table (Active or Changed Log) is used for delta upload.

Deepon

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi Deepon,

active table is used for full upload,

and change log is used for init/delta.

hope this helps.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

In ODS there is 3 DDIC table

/BIC/AYSODS100 ODS object YSODS1 : Active records

/BIC/AYSODS140 ODS Object YSODS1 : Update

/BIC/AYSODS150 ODS Object YSODS1 : Rollback

the /BIC/A<ODS name>40 contain upload data before activation.

When yo activate data, the date will be transfer from /BIC/A<ODS name>40 to /BIC/A<ODS name>00.

When all data are acivated, the /BIC/A<ODS name>40 table is empty.

After a full upload you can't do an init and delta, but you can do a full after a delta.

Full / Delta is possible only if you extractor can do delta extraction.

I hope it can help you.

BR Daniel

Former Member
0 Kudos

You can't do delta loads to ODS with full loads and viceversa. It will gives you an error in BW

Former Member
0 Kudos

Say for example if your ODS name is YSODS1.

Your tables would be:

/BIC/AYSODS100 ODS object YSODS1 : Active records

/BIC/AYSODS140 ODS Object YSODS1 : Update

/BIC/AYSODS150 ODS Object YSODS1 : Rollback

IF you need delta , you need to set up init selections for your delta , do a delta initialization without data transfer and then onwards delta..