Page 1 of 1
please list out active and passive stages in datastage
Posted: Tue Dec 06, 2005 6:11 am
by 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
Posted: Tue Dec 06, 2005 8:19 am
by 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.
Posted: Tue Dec 06, 2005 8:20 am
by 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.
Posted: Tue Dec 06, 2005 1:34 pm
by ray.wurlod
Open the stage type's properties in the Stage Types branch of the Repository to determine its active/passive status.
active and passive satges of dstage
Posted: Wed Dec 07, 2005 3:35 am
by 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
Posted: Wed Dec 07, 2005 3:52 am
by ray.wurlod
Please check the following.
FTP stage
ORABULK stage
Re: active and passive satges of dstage
Posted: Wed Dec 07, 2005 8:07 am
by poorna_76
sekharg_dw wrote: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.
Posted: Tue Mar 28, 2006 12:58 pm
by zbethem
ray.wurlod wrote:Please check the following.
FTP stage
ORABULK stage
both are passive
Posted: Tue Mar 28, 2006 3:27 pm
by 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.