you can just uncheck the option full load always thats it. Actually it will be decided based on the value of the refresh date for the primary source or primary target table, If the refresh date is null DAC will automatically choose the task with full load workflow and if there is a value available for the refresh date DAC will execute the respective incremental workflow You can check that under setup tab for oracle connections it should show the latest date in order to run the incremental load
hope it helps
Thanks for the quick reply!!!
I have unchecked full load always option and tried to run incremental load but session got failed
with the error:
ORA-00001: unique constraint (Unique index name) violated
Can you please help me with this
Thanks in Advance
unique constraint comes when you have duplicate key. you can query the DB for the table with unique indexes and delete them and run the load again it will succeed
Do I have to delete them everytime I run an incremental load
no, only when you have duplicate primary keys
Thanks for the reply !!!