Teradata Stages

[kumar_j]

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?

[sud]

Teradata enterprise stage

[trokosz]

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....

[hamzaqk]

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

[ray.wurlod]

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