please list out active and passive stages in datastage

[sekharg_dw]

Hi all,
im new to datastage i dnt hv manual ...
please list out the active stage and passive stages !
example :- Oracle -- active/passive
seq file ?


wether dsapi_slave invokes for both active / passive ..
still the topic is out of my scope i would like hv more detail discussion ...



thnsk
---s

[sjhouse]

Online manuals are loaded with your DataStage client. Use those to familiarize yourself with DataStage and its components. Also, being new, you should take a DataStage training offered by IBM.

[ArndW]

If you have a client installed then you do have the documentation; if you don't have a client or a server then any explanation here is going to be somewhat useless.

There is no reason to make an inclusive list of active and passive stages since they will change over time and with addition of packages.

The definition of a passive stage for your purposes is one that reads from a source or writes to a target, i.e. an I/O stage. A bit deeper definition is that active stages are one or more processes at runtime, while passive stages are not.

Although I haven't checked, using the SEARCH functionality will certainly give you many (better) definitions. It would be wise to use this first and if the answer isn't clear then you can post for clarification.

[ray.wurlod]

Open the stage type's properties in the Stage Types branch of the Repository to determine its active/passive status.

[sekharg_dw]

list of active and passive satges

PASSIVE STAGES

db2/udb
dynamic rdbms
ms oledb
Odbc
universe &unidata
oracle
redbrick load
stored procedure
Sybase
Teradata
complex flat file
sequential file
folder
hashed file

ACTIVE STAGES

Aggregator
command stage
ftp plugin
inter process
link collector
link partinioner
merge
pivot
row merger
row splitter
sort
transformer

tnks
Ardy

[ray.wurlod]

Please check the following.

FTP stage

ORABULK stage

[poorna_76]

list of active and passive satges

PASSIVE STAGES

db2/udb
dynamic rdbms
ms oledb
Odbc
universe &unidata
oracle
redbrick load
stored procedure
Sybase
Teradata
complex flat file
sequential file
folder
hashed file

ACTIVE STAGES

Aggregator
command stage
ftp plugin
inter process
link collector
link partinioner
merge
pivot
row merger
row splitter
sort
transformer

tnks
Ardy

I don't think InterProcess is ActiveStage,
its a Passive Stage.

[zbethem]

Please check the following.

FTP stage

ORABULK stage

both are passive

[ray.wurlod]

Depends what version. Early versions of the ORABULK stage were written as active, so that it could support an after-stage subroutine via which you could invoke sqlldr.