DataStage Naming Standard

For maintaining the design and easy understanding of what happening inside the job, we are giving meaningful name to stages, links, jobs and sequencer. So that other developer/designer can have a idea about purpose of job/seq by seeing the design.

Here I have shared some DataStage Naming Standard we usually follow.

Object Type		Syntax
Category		Import/transform/unload
Job		jb_fdXX_<im/tr/ul>_<JobName>
		Where XX is 01,02…13 indicating FD name.
		<im> indicates Import Job
		<tr> indicates Transform Job
		<ul> indicates Unload Job
Job Sequence		js_<fdXX>_<im/tr/ul>_<file/detail>
		Where XX is 01,02…13 indicating FD name.
		<im> indicates Import Job Sequence
		<tr> indicates Transform Job Sequence
		<ul> indicates Unload Job Sequence
Source Definition Category		source
Target Definition Category		target
Link*		lnk_<StageName>_<rej/njn/jn>
		lnk_<StageName>
		<StageName> is the name of the stage from which the link is coming out.
		<rej/njn/jn> indicates the type of link rej=reject, njn=non join, jn=join. If not
		applicable then this will be dropped.
Data Set		ds_<Dataset Name>
Sequential File		sq_<Sequential file name>
File Set		fs_<File Set name>
Lookup File Set		lfs_<Lookup file set name>
External Source		esrc_< External Source name>
External Target		etrg_< External Target name>
Complex Flat File		cff_< Complex Flat File name>
Transformer		tr_<Purpose>
BASIC Transformer		btr_<Purpose>
Aggregator		agg_<Purpose>
Join		jn_<Purpose>
Merge		mrg_<Purpose>
Lookup		lkp_<Purpose>
Sort		srt_<Purpose>
Funnel		fnl_<Purpose>
Remove Duplicates		rdup_<Purpose>
Compress		cps_<Purpose>
Expand		exp_<Purpose>
Copy		cp_<Purpose>
Modify		md_<Purpose>
Filter		flt_<Purpose>
External Filter		sflt_<Purpose>
Change Capture		ccap_<Purpose>
Change Apply		capp_<Purpose>
Difference		diff_<Purpose>
Compare		cmp_<Purpose>
Encode		enc_<Purpose>
Decode		dec_<Purpose>
Switch		cwt_<Purpose>
Generic		gen_<Purpose>
Surrogate Key		sur_<Target Column Name>
Column Import		ci_<Purpose>
Column Export		ce_<Purpose>
Make Subrecord		msub_<Purpose>
Split Subrecord		ssub_<Purpose>
Combine Records		crec_<Purpose>
Promote Subrecord		prec_<Purpose>
Make Vector		mkv_<Purpose>
Split Vector		splv_<Purpose>
Local Container		lc_<functionality>
Shared Container		sc_<functionality>
Stage Variable		s_<StageVariableName>
Sequence Generator		seq_<Target Column Name>
Job Sequences		Stages
Job Activity		ja_<job name without jb and fd#>
Execute Command		ex_<Script function>_<file/detail>
Sequencer		sq_<Purpose>

More :--->  ETL Job Design Standards - 1