I am trying to run a full load by selecting Reset Data Sources in DAC. However, when i select this option, only the data after Jan 11, 2014 gets picked up in the ETL. I have data starting from year 2010 in my database.
How do i ensure that the full set of data gets picked up for full load?
The value of INITIAL EXTRACT DATE is as follows:
|$$INITIAL_EXTRACT_DATE||Timestamp||Value=19700101 at 00:00:00:00_dac_sep_Formatter=MM/DD/YYYY_dac_sep_Function=TO_CUSTOM_dac_sep_Runtime=Static|
How does this work? Actually this was working fine for DAC 10g and the client was able to perform full loads by resetting the data sources.
What could be the issue with DAC 11g?
you need to change the date from the accounting period start date(as you want from Jan xx 2010) the above value is default(jan 1 1970) so you need to make changes accordingly and then start the full load. make sure you are making changes to the container you are using for running the full load