Teradata Stages

[just4geeks]

Hello,

I am researching on using Teradata Stages for for my next potential assignment. I see there are multiple Teradata stages. I would like to know which stage can be used with server or parallel jobs or both:

1. Using ODBC stage - I guess this can be used in Server as well as Parallel.

2.Teradata API stage (Plug-in Stage)- As far as I know it can surely be used in Server Jobs. Can it be used in Parallel jobs as well?

3. Teradata Load stage (Plug-in Stage)- : I am not sure but I think it can be used in Parallel as well as Server. Any Clues?

4. Teradata MultiLoad/TPump/FastExport stage (Plug-in Stage)- : I am not sure but I think it can be used in Parallel as well as Server. Any Clues?

5. Teradata Enterprise Stage- Can only be used in Parallel jobs

Please help me in removing my confusion.

Thanks in advance!

[ray.wurlod]

Which stage types can be used in which job types is easily established - just look on the Palette for the job type that you have open.

[just4geeks]

Hello Ray!

Thanks a lot for your response. As I said, I am researching this for a potential assignment on another project. Since most of these are plug-ins, they are not installed on my current DataStage environment.

Take care

[keshav0307]

search is good option.

http://it.toolbox.com/blogs/dw-soa/ibm- ... data-19417

[just4geeks]

search is good option.

http://it.toolbox.com/blogs/dw-soa/ibm- ... data-19417

This is fantastic article. It is must read for any DataStage-Teradata user/learner. Thank you so much for the link!

However it does not state which stage can be used with Server or Parallel?

Take care