on 12-20-2006 3:15 PM
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
hi Deepon,
active table is used for full upload,
and change log is used for init/delta.
hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can't do delta loads to ODS with full loads and viceversa. It will gives you an error in BW
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.