I need to run a full load for 20 years of data. I am using Informatica as ETL tool and OBIEE as my Reporting tool.
I am having huge volume of data in my EBS (Source). So that, I am planning to run a full load for first 10 years. Lets take an example, 1993 to 2003. After this load completes, I need to run again full load from 2003 to 2013. Finally I will have the data in my Target Database (Oracle) for 20 years.