I have an issue with load data from xml to oracle DB at load data step.
when I performing each execution, previous data fetching. so, c$ table loading previous and current execution data.it seems, drop_on_disc property not working.
Could you please assist on this issue. how to resolve this issue.
I made changes for dp_Varchar_length and default_length_Varchar in xml driver property after that I faced this issue.
I have restarted agent and removed cache as well but no luck. Could you please provide your solution. Thanks in advance.
each execution c$ table fetching previous run records. c$ drop also working and creating new c$ table each run but fetching previous run records from schema.
select COUNT(1) from schema.C$_abc --20 --First run
select COUNT(1) from schema.C$_abc --40 --2nd run
select COUNT(1) from schema.C$_abc --60 --3rd run
My source xml file contains 20 records.
Thanks for your support in advance.