Informatica help

Informatica help and metadata report query

Informatica naming Conventions

Informatica naming Conventions best practice.

This page will show you the recommended best practice of Informatica naming Conventions option,
please note, it does not obligate you to use it in your organisation.

Type Description Naming Conventions Remarks
REPOSITORY FOLDERS Shared source A_Shared_Sources Start with A so it will be on top of the folder list
REPOSITORY FOLDERS Shared Target A_Shared_Target Start with A so it will be on top of the folder list If you have specific system you can add it to the name
REPOSITORY FOLDERS Shared Objects A_Shared_Objects Start with A so it will be on top of the folder list If you have specific system you can add it to the name
REPOSITORY FOLDERS Project P_ Or Just Start with P for Project, you can chose any other letter or none
WORKFLOW NAMES Workflow wkf or wf_{DESCRIPTOR}
WORKFLOW NAMES Worklet wk or wklt_{DESCRIPTOR}
WORKFLOW NAMES Command Object cmd_{DESCRIPTOR}
WORKFLOW NAMES Session s_{MappingName}
WORKFLOW NAMES Email Task Email_ or eml_{DESCRIPTOR}
WORKFLOW NAMES Assign Task asgn_{DESCRIPTOR}
WORKFLOW NAMES Decision Task dcn_ or dt_{DESCRIPTOR}
WORKFLOW NAMES Timer Task Timer_ or tmr_{DESCRIPTOR}
WORKFLOW NAMES Event Raise Task raise_ or er_{DESCRIPTOR} Represents a user-defined event. When the PowerCenter Server runs the Event-Raise task, the Event-Raise task triggers the event. Use the Event-Raise task with the Event-Wait task to define events.
WORKFLOW NAMES Event Wait Task wait_ or ew_{DESCRIPTOR} Waits for an event to occur. Once the event triggers, the PowerCenter Server continues executing the rest of the workflow.
WORKFLOW NAMES Control Task ctl_{DESCRIPTOR} Waits for an event to occur. Once the event triggers, the PowerCenter Server continues executing the rest of the workflow.
TRANSFORMATION OBJECTS Advanced External Procedure Transformation aep_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Aggregator Transformation agg_ follow by the leverages the expression or a name that describes the processing being done
TRANSFORMATION OBJECTS Expression Transformation exp_ follow by the leverages the expression or a name that describes the processing being done
TRANSFORMATION OBJECTS Filter Transformation fil_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Joiner Transformation jnr_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Lookup Transformation lkp_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Mapplet mplt_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Normalizer Transformation nrm_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Rank Transformation rnk_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Source Qualifier Transformation sq_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Update Strategy Transformation upd_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Stored Procedure Transformation sp_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Sequence Generator Transformation seq_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Router Transformation rtr_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Sorter Transformation srt_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Custom Transformation cust_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Transaction Control Transformation trctrl_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS XML Source Qualifier Transformation XMLsq_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Application Source Qualifier Transformation Appsq_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS MidStream XML Parser Transformation XMLprse_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS MidStream XML Generator Transformation XMLgen_ follow by the process name that the transformation should do
TRANSFORMATION OBJECTS Union Transformation un_ follow by the process name that the transformation should do

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast