truncating and recreating target tables
ggworthyNov 28 2011 — edited Nov 30 2011On our source database we have a weekly job that truncates and loads data into a 5 tables. During this weekend run, the job ran perfectly on the source. However the corresponding tables in the target database doubled, instead of being truncated and reloaded.
any configratuin required to support this ?
Can I delete the duplicate rows on the target directly ? This may be risky since some of the columns in the dupllcate rows are different and I am not sure which one to retain.
Can truncate / drop there table on the Golden Gate target and import from the prod. Will this cause any issue.