how to do partial load at script level

[ysalvi43]

Hello Team,

I have 2 tables where table 1 consists of 1000 records and table 2 is dynamic on daily bases it will get updated.

so I have one query  that when loading script is it possible to not load table 1 in script and script should directly start loading from 2 and not from 1.

~ Yash Salvi 

[anat]

create variable then try to use the if condition like below:

set var=2;

if var=1 then
TableA:
load * inline [
field
a
b
c
];

else

TableB:
load * inline [
field
d
e
f
];

end if;

[ysalvi43]

Hey Anat,

above solution is fine, but what if data is getting reloaded daily/weekly basis??? how can we automate that?? because loading full script seems to be time consuming.

~ Yash Salvi