Question:
Hello Guru's,
Our Existing System:
We have one cube(1). the data is loaded into the cube by using a custom extractor from R/3.Right now we are doing only Full Loads.
Our New Requirement:
We have created one more cube(2).now we want to load delta data into this new cube for every one hour and load delta data into the first cube for every three months from the same Custom Extractor Datasource.
Please advise me the best way to go about to reach our new requirement.
Here is what i thought. we will create two ODS objects and load the data .Setup the Delta from each ODS to the respective cubes for different times.please advise me if there is any other way of designing this.
Thanks in Advance.
Answer:
U r on the right track. Go ahead create ODS
s and do the delta out of it.