DSXchange

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?

Hi , just depends on the situation

if u r trying to populate an empty table then u can use fast load(always for empty tables)...

the only thing u can use for populating non empty table is the multiload and teradata api ...

and yes u can use teradata api in server jobs

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~