Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to use Partial Reload inside a normal Load?
I have a incrementall load for a couple of table, but one of these need to be Replaced with new data.
To do a full Load on that table every time is ofcourse a way to solv the problem, but...
Use Replace function in load statement this will drop old data both normal and partial reload and replace with new data
With Partial Reloads you use the Replace in the script and these tables are all that are reloaded with a partial reload.
Replace load * from File1.csv;
So, on the above this would be loaded on both a full and a partial reload.
load * from File2.csv;
would only be reloaded on a full and not a partial reload.
Bill