This discussion is archived
0 Replies Latest reply: Dec 11, 2013 2:00 AM by SakthirajSelvaraj RSS

How to split DAC Full Load by years?

SakthirajSelvaraj Newbie
Currently Being Moderated

Hi Oracle Friends,

 

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.

 

It will be appreciated if you help me on this.

 

Thanks,

Sakthi.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points