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