on 06-02-2006 3:38 PM
We wonder if the Full load does remove the previous requests or data and bring over new data?
For example, we extract data from a R3 table by using Full load. 1st day, we load data to R3 table, then extract the data to BW, then BW data contains only 1st day data. 2nd day, we delete R3 table data and load data for 2nd day only, then extract to BW still using the Full load, then what BW data should contain? both 1st day and 2nd day data? or 2nd day data only?
Any answer?
Thanks
Hi Kevin
The answer to your question is <b>NO</b>.
You have the option of deleting a previous upload of the same data in the InfoPackage.
If you load to a cube all the uploads are added together. If you load to an ODS then a delta is automatically generated when activating ODS, one advantage of this is that you do not get double data if you load the same data twice.
Regards
German
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi All,
I am sorry that I forgot to mention that the data is extracted to a BW ODS other than a cube. When we conduct the 2nd day extract to the ODS, then the data with the same key would be overwritten, that would be out of question. My question is that if the 1st day data with different key would be removed from the ODS or still stay? Note: the update mode to the ODS is Full.
Thanks
hi Kevin,
if you didn't delete 1st day's requst in bw,
then bw will contain 1st and 2nd day data.
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 Kevin,
What data the cube should have should be decided by the business requirement.
Current data load will delete the existing data only if that option has been selected in the Infopackage, else it is going to get appended.
You may assign points if helpful ****
Thanks,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kevin,
BW will contain all the data (Day 1 and Day 2). If you are loading to a cube, then all the data from Day 1 and Day 2 will be present in the cube. If you are loading in the ODS, there is a chance that some data is overwritten the second day.
But in no case is the previous data automatically deleted just by the load, unless you have made any deletion settings.
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.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.