DataStage Job Report for LoadEtlJob2

Collapse All | Expand All | Show Default

LoadEtlJob2
DataStage Job Report
Generated 2005-02-15 08:26:49pm

- Job Design

- Job Information

- Job Properties (7)

Property	Value
Object Type	Server
Short Description	Last Changed: 07-29-2004
Full Description	Job: LoadEtlJob2 ------------------------------------------------------------------------------------- Non-technical description: Load ETL_JOB with job category. ------------------------------------------------------------------------------------- Business rules: Runs from SeqPrepareEtlStats. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: None ------------------------------------------------------------------------------------- Sources: tbd ------------------------------------------------------------------------------------- Targets: tbd ------------------------------------------------------------------------------------- Modification History: ------------------------------------------------------------------------------------- UserId Date Version Modification Description ------------------------------------------------------------------------------------- kduke 07-29-2004 1 Created job. -------------------------------------------------------------------------------------
Category	EtlStats
Multiple Instance	False
Job Version Number	40.1.1
Hash File Cache Sharing	False

- Annotations (1)

#	Annotation
1	LoadEtlJob2

- Parameters (3)

Parameter Name	Prompt	Default Value	Help Text
TargetDSN	TargetDSN	kduke
TargetUser	TargetUser	etluser
TargetPwd	TargetPwd	LDH@9:VA=93L0O5I<;J

- Stages (3)

- Source Stages (1)

ETL_JOB_LINK (oraoci8)

- Processing Stages (1)

TransEtlJobHist (transformer)

- Target Stages (1)

ETL_JOB (oraoci8)

- Source Stages (1)

- ETL_JOB_LINK (oraoci8)

- Stage Desc

#TargetDSN#
#TargetUser#
#TargetPwd#

- Stage Properties (4)

Property	Value
DATABASE	#TargetDSN#
USERID	#TargetUser#
PASSWORD	HD:@I:V@L93?0GEI<;J<0K1GB
ISOPS	NO

- Output Links (1)

+ ETL_JOB_LINK triggers TransEtlJobHist

+ Custom Properties (13)

+ Columns (3)

- Processing Stages (1)

- TransEtlJobHist (transformer)

+ Stage Variables (0)

- Input Links (1)

+ ETL_JOB_LINK triggered by ETL_JOB_LINK

- Output Links (1)

+ ETL_JOB triggers ETL_JOB when ETL_JOB_LINK.JOB_CATEGORY[1,4] <> "User" and ETL_JOB_LINK.JOB_CATEGORY[1,1] <> "z" and upcase(ETL_JOB_LINK.JOB_NAME[1,1]) <> "Z" and upcase(ETL_JOB_LINK.JOB_NAME[1,1]) <> "X"

- Target Stages (1)

- ETL_JOB (oraoci8)

- Stage Desc

#TargetDSN#
#TargetUser#
#TargetPwd#

- Stage Properties (4)

Property	Value
DATABASE	#TargetDSN#
USERID	#TargetUser#
PASSWORD	HD:@I:V@L93?0GEI<;J<0K1GB
ISOPS	NO

- Input Links (1)

+ ETL_JOB triggered by TransEtlJobHist

Ascential and DataStage are trademarks of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions.
For questions or comments regarding this utility, contact tony.curcio@ascentialsoftware.com.

Property	Value
TABLE	ETL_LINK
ISCASESENS	NO
GENSQL	FullyGenSQL
USERSQL	SELECT ETL_LINK.PROJECT_NAME,ETL_LINK.JOB_NAME,ETL_LINK.JOB_CATEGORY FROM ETL_LINK group by PROJECT_NAME, JOB_NAME, JOB_CATEGORY
FULLYGENSQL	SELECT ETL_LINK.PROJECT_NAME, ETL_LINK.JOB_NAME, ETL_LINK.JOB_CATEGORY FROM ETL_LINK ETL_LINK GROUP BY ETL_LINK.PROJECT_NAME, ETL_LINK.JOB_NAME, ETL_LINK.JOB_CATEGORY
Pre42BINDING	Yes
ARRAYSIZE	1
OTHER_CLAUSES	group by PROJECT_NAME, JOB_NAME, JOB_CATEGORY
TX_ISO_LEVELO	Read Committed
CONTBEFORESQL	YES
CONTAFTERSQL	YES
DISABLEWARNS	Yes
QUERYDEF	JTYPE=0;SCOLS=;;D="";DEF=;X=ETL_LINK.PROJECT_NAME;T=9;;F=VarChar;G=;Z=;K=50;M=0;N=FALSE;b=ETL_LINK;A=PROJECT_NAME;S=1;B=;;;D="";DEF=;X=ETL_LINK.JOB_NAME;T=9;;F=VarChar;G=;Z=;K=255;M=0;N=FALSE;b=ETL_LINK;A=JOB_NAME;S=1;B=;;;D="";DEF=;X=ETL_LINK.JOB_CATEGORY;T=9;;F=VarChar;G=;Z=;K=255;M=0;N=FALSE;b=ETL_LINK;A=JOB_CATEGORY;S=0;B=;;;WCONC=;;HCONC=;;GCOLS=;;X=;X=ETL_LINK.PROJECT_NAME;T=9;;;;X=;X=ETL_LINK.JOB_NAME;T=9;;;;X=;X=ETL_LINK.JOB_CATEGORY;T=9;;;;OCOLS=;;TABS=;;F=Kim\StgDev20040729v2\ETL_LINK;G=ETL_LINK;N=ETL_LINK;O=;S=ETL_LINK;;;

Column Name	Data Type	Description	Derivation
PROJECT_NAME	VarChar [50]
JOB_NAME	VarChar [255]
JOB_CATEGORY	VarChar [255]

Column Name	Data Type	Description	Derivation
PROJECT_NAME	VarChar [50]
JOB_NAME	VarChar [255]
JOB_CATEGORY	VarChar [255]

Column Name	Data Type	Description	Derivation
PROJECT_NAME	VarChar [50]		ETL_JOB_LINK.PROJECT_NAME
JOB_NAME	VarChar [255]		ETL_JOB_LINK.JOB_NAME
SEQ_IND	VarChar [1]		If IsJobSequence(ETL_JOB_LINK.JOB_NAME) Then "Y" Else "N"
JOB_CATEGORY	VarChar [255]		ETL_JOB_LINK.JOB_CATEGORY

Property	Value
TABLE	ETL_JOB
ISCASESENS	NO
GENSQL	Yes
USERSQL	INSERT INTO ETL_JOB (PROJECT_NAME,JOB_NAME,SEQ_IND,JOB_CATEGORY) VALUES (:1,:2,:3,:4)
Pre42BINDING	Yes
ARRAYSIZE	1
TRANSSIZE	0
CREATETABLE	No
GENCREATEDDL	Yes
USERCREATEDDL	CREATE TABLE ETL_JOB ( PROJECT_NAME VARCHAR(50) NOT NULL, JOB_NAME VARCHAR(255) NOT NULL, SEQ_IND VARCHAR(1), JOB_CATEGORY VARCHAR(255) , PRIMARY KEY (PROJECT_NAME, JOB_NAME) )
DROPTABLE	No
GENDROPDDL	Yes
USERDROPDDL	DROP TABLE ETL_JOB
DODELETE	Yes
DOUPDATE	Insert rows
TREATWARNASFATAL	NO
TX_ISO_LEVELI	Read Committed
CONTBEFORESQL	Yes
CONTAFTERSQL	Yes