IIS Datastage Naming Conventions and Standards

Standards, Infosphere, Information Server, Datastage Naming Conventions and Standards

Standards

The standardized naming conventions ease the burden on developers switching from one project to another.  Knowing the names and where things are located are very useful to understand jobs or sequences and aides in the time to productivity of new team members.  This is also true for augmentation resources, which may need to be brought in assist your team.

The following tables identify DataStage elements and their standard naming convention.

Job Naming Conventions

Entity Convention
Parallel Job <<Application>>_<<job_Name>>_Prl
Server Job <<Application>>_<<job_Name>>_Svr
Sequence <<Application>>_<<job_Name>>_Seq
Extract Job  (Multipart processes only) <<Application>>Src<<job_Name>>_<<Job Type (Prl or Svr)>>
Load (Multipart processes only) <<Application>>Load<<job_Name>>_<<Job Type (Prl or Svr)>>
File Generation/Output (Multipart processes only) <<Application>>_FG<<job_Name>><<Job Type (Prl or Svr)>>

 

Properties Naming Conventions

Entity Convention
Parallel Shared Container <<Application>>_<<job_Name>>_Psc
Parameter <<Application>>_<<job_Name>>_Parm
Parameter_set <<Application>>_<<job_Name>>_ParmSet
Server Shared Container <<Application>>_<<job_Name>>_Ssc

Job Processing Stage Naming Conventions

Entity Convention
Aggregator Agg_<<PrimaryFunction>>
Change Apply ChAp_<<PrimaryFunction>>
Change Capture  ChCp_<<PrimaryFunction>>
Copy Cp_<<PrimaryFunction>>
Funnel Funl_<<PrimaryFunction>>
Join (Inner) InJn_<<PrimaryFunction>>
Join (Left Outer) LOJn_<<PrimaryFunction>>
Join (Right Outer) OJn_<<PrimaryFunction>>
Join (Full Outer) FOJn_<<PrimaryFunction>>
FTP Enterprise Ftp_<<PrimaryFunction>>
Lookup Lkp_<< Value Name or table Name>>
Merge Mrg_<<PrimaryFunction>>
Column Export CExp_<<PrimaryFunction>>
Column Import XImp_<<PrimaryFunction>>
Pivot Pivt_<<PrimaryFunction>>
Remove Duplicates RmDp_<<PrimaryFunction>>
Row Generator RGen_<<Job_Name>>
Slowly Changing Dimension SCD__<<PrimaryFunction>>
Sort Srt_<<PrimaryFunction>>
Surrogate Key Generator SKey_<<PrimaryFunction>>

 

Links Naming Conventions

Entity Convention
Reference (Lookup) Ln_Ref_<<Number or Additional descriptor, if needed to form a unique object name>>
Reject (Lookup, File, DB) Ln_Rej_<<Number or Additional descriptor, if needed to form a unique object name>>
Get (Shared Container) Ln_Get_<<Number or Additional descriptor, if needed to form a unique object name>>
Put (Shared Container) Ln_Put_<<Number or Additional descriptor, if needed to form a unique object name>>
Input Ln_In_<<Number or Additional descriptor, if needed to form a unique object name>>
Output Ln_Out_<<Number or Additional descriptor, if needed to form a unique object name>>
Delete Ln_Del_<<Number or Additional descriptor, if needed to forma a unique object name>>
Insert Ln_Ins_<<Number or Additional descriptor, if needed to form a unique object name>>
Update Ln_Upd_<<Number or Additional descriptor, if needed to form a unique object name>>

 

Database Stage Naming Conventions

Entity Convention
Reject Rej_<<Table or Object Name>>
Lookup Lkp_<<Table or Object Name>>
Source Src_<<Table or Object Name>>
Target Tgt_<<Table or objectName>>

Transformer Stage Naming Conventions

Entity Convention
Loop Variable Lv_<<objectName>>
Stage Variable SV Sv_<<objectName>>
Transformer (native parallel) Tfm__<<objectName>>

File Stage Naming Conventions

Entity Convention
Sequential File SF__<<objectName>>
Complex Flat File CFF__<<objectName>>
File Set FS__<<objectName>>
Parallel dataset DS__<<objectName>>
Lookup File Set LFS__<<objectName>>
External Source XSrc__<<objectName>>
External Target XTgt__<<objectName>>

XML & Real-Time Stages Naming Conventions

Entity Convention
RTI Input RTIi_<<objectName>>
RTI Output RTIo_<<objectName>>
XML Input XMLi_<<objectName>>
XML Output XMLo_<<objectName>>
XML Transformer XMLt_<<objectName>>

Sequence Object Naming Conventions

Entity Convention
Sequence <<Application>>_SEQ_<<Application job Stream Name>>
Master Control Sequence (parent) <<Application>>_SEQ_Master_<<Application job Stream Name>>

 

Sequence Stage Naming Conventions

Entity Convention
Error Handler EH_<<PrimaryFunction>>
Job Activity Job_<<PrimaryFunction>>
Nested Condition NC_<<PrimaryFunction>>
Routine Activity Rtn_<<PrimaryFunction>>
Sequencer (All) SeqAll_<<Identifier>>
Sequencer (Any) SeqAny_<<Identifier>>
Notify Notify_<<PrimaryFunction>>
Terminator Activity TA__<<PrimaryFunction>>
Sequence Links (Non-messages) Lnk_<<Number or Description>>
Sequence Links (messages) Msg_<<Number or Description>>

Related References

 

Advertisements

One thought on “IIS Datastage Naming Conventions and Standards

  1. Pingback: DataStage – How to add or subtract from a date in a transformer stage | Scientia Compendium

Comments are closed.