DSXchange

Hi Gurus,
.I want to access 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 Enterprise 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 on parallel job?

Teradata enterprise stage

Teradata Enterprise Stage is the best performance providing you set sessiosperrequest and requestsperplayer options properly.....there is a strategy on this....it runs in parallel....

Multiload is a sequential operation and not parallel....Its there but not a good option.....in my opinion....

Multiload allows you to load upto 5 populated tables at the same time.... as its a Teradata API it self so it is based on a pararell architecture.

use fastload for empty tables only

Actually, FastLoad in DataStage can make a call through the API to append new rows to tables that already contain rows.