Skip to Content
0
Former Member
Oct 07, 2005 at 01:07 PM

Data Load Question

43 Views

Ok Experts,

I'm confused. I'm trying to replicate a salescube in production that has data for several different years. The volume of sales orders per day is so big that I can't do a full load with a date range such as 0PSTNG_DATE=20030501-20050505 . This would take several weeks to load.

So, I thought I could do several full loads on just a small portion of each year. I need about three different years of data because I have created a cube for each year. We have a huge cube in production with 800 million records and we are trying to split it into multiple cubes for a multiprovider.

Is it valid to do several full loads with the following selection.

full load #1 - 0PSTNG_DATE=20050501-20050505

then full load #2 - 0PSTNG_DATE=20040501-20040505

then full load #3 - 0PSTNG_DATE=20030501-20030505

in three separate steps to accumulate the data? When I ran #2 and #3 it told me no data found but I know there is data for this time period.

( will award points )

Thanks

Richard