What is the difference between staging are diffrent from target
SahadevaMar 14 2013 — edited Mar 15 2013Hi,
My question is what is the diffrence between staging are different from target and staging area same as target.
To Say,
I am loading some data from file to database table. Generally what happens is it will create temp tables C$, I$, E$. C$ table will delete the previous table information and
create a new table and then load the data to staging I$ and then E$ for error checking. So here the question is if I select the option staging are same as target in that
case if we load the data to target will move or otherwise to where the data goes.
Help me out in this...
Thx,