on 03-24-2008 5:01 PM
I have read many threads on this topic, still have some questions. To give you background, I will be doing delta load (delta process chain). But before delta, I want to do setup initialization (init process chain). I want to use this process type in my init process chain to delete all data in my cube loaded from a specific ods. I cannot use delete all contents process type because many odss feed the same cube.
1. Do you put this process type after Load Data or before Load Data. I have seen both cases in SDN forums.
2. Variant of this process type is an info package. Does this info package have to be same as in load data step or it can be different.
3. I want to delete all data in cube which was loaded from my ods. Term overlapping is confusing to me. Will this process type delete all data or not.
Tanks in advance.
Hi,
I remember, you should select the setting 'delete contents before load' in the infopackage. so when this infopackage is run, the contents of the infocube is deleted before loading. In case the load fails the data wont be deleted.
Is this what you are looking for or something else?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, you can do that. Goto RSPC - under process types Load Process and Post Processing, you will see DELETE OVERLAP REQUESTS FROM INFOCUBE option is there.
Select the proper check boxes like same sourcesystem, same datasource etc...
If it is one time deletion, why not do that manually?
Hope it helps..
User | Count |
---|---|
84 | |
25 | |
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.