Skip to Content
0
Former Member
Mar 23, 2009 at 07:14 AM

ODS data load modification.

24 Views

Hi Gurus,

I have one question regarding data load in ODS object.

We have one ODS object lets say A which is populating data from below 2 ODS object in delta method.

From A Ods data is getting inputed to one APD(Analysis process designer),this data volume is huge & it's taking almost 8 hours to in APD.

Now,logically I thought like if I can load the data from A,to one more new ODS obj.let's say B on a daily basis & delete the all previous data from ODS B (this ODS will have only current data) then we can have only specific day's record in the new ODS B which will be less in number assume 3thousand.Then inputing only this many data into APD will take less time obviously.

Now,do we have any procedure to do the load in this way??

Any suggestion,any help........

Regards,

Kironmoy Banerjee