Hi,
My target is a Teradata table. Since I am new to Teradata, not sure whether I use Teradata Enterprise stage or Teradata Multi load stage.
Or in other words, when to use enterprise stage and when to use multiload stage.Please help.
Thanks,
Teradata Stage
Moderators: chulett, rschirm, roy
Hi ,
Teradata enterprise stage is like fast load in teradata.
For fast load in teradata,
Target table must be empty and constraints free and it won't allow any index other than primary index.
in fast laod we can do insert only.
Where as in mload ,
we can load data even though it has data in target table
we can do insert ,update and delete through mload.
Regards,
Sankar.
Teradata enterprise stage is like fast load in teradata.
For fast load in teradata,
Target table must be empty and constraints free and it won't allow any index other than primary index.
in fast laod we can do insert only.
Where as in mload ,
we can load data even though it has data in target table
we can do insert ,update and delete through mload.
Regards,
Sankar.
sa