Hi Gurus,
.I want to Extract and load teradata data by using the Data stage job, so please suggest Which stages are preferable in terms of performance point of view.
I think Teradata Load and Multi load stages are available in parallel jobs.Is there any other stages (like plug-in's) to access teradata
Is Teradata API Works in Server job?
Teradata Stages
Moderators: chulett, rschirm, roy
Re: Teradata Stages
You have Teradata Load, Multi load and T-pump stages in server Jobs.
M-load stage works like a bulk load utility for loading and also works as fast export stage for reading data. Its lot faster than API stage however it has its own limitations interms of what you can do and what not.
You don't want do any kind of aggregation while using M-load stage for loading or extracting.
Kris~
M-load stage works like a bulk load utility for loading and also works as fast export stage for reading data. Its lot faster than API stage however it has its own limitations interms of what you can do and what not.
You don't want do any kind of aggregation while using M-load stage for loading or extracting.
Kris~
~Kris