DataStage ETL Stages

admin on May 2nd, 2012

Data Stores: For the purposes of this section, a data store is a physical piece of disk storage where data is held for a period of time. In DataStage terms, this can be either a table in a database structure or a file contained in a disk directory or catalog structure. Data held in a database […]

Continue reading about Data Stores

admin on May 2nd, 2012

Sequencer Object Naming: In a job Sequencer, links are actually messages. Proceed sequencer links with the class word msg_ followed by the type of message (as examples, fail and unconditional), and followed by the ClassName. The following lists shows some examples: Reception Succeeded Message: msg_ok_Reception Reception Failed Message: msg_fail_Reception

Continue reading about Sequencer Object Naming

admin on May 2nd, 2012

Stage Names: DataStage assigns default names to stages as they are dragged onto the Designer canvas. These names are based on the type of stage (Object) and a unique number, based on the order the object was added to the flow. In a job or job sequence, stage names must be unique.

Continue reading about Stage Names

admin on May 2nd, 2012

Links: In a DataStage job, links are objects that represent the flow of data from one stage to the next. In a job sequence, links represent the flow of a message from one activity or step to the next. In a DataStage job, links are objects that represent the flow of data from one stage to the […]

Continue reading about Links

admin on May 2nd, 2012

Shared Containers: Shared containers have the same naming constraints as jobs in that the name can be long but cannot contain underscores, so word capitalization must be used for readability. Shared containers might be placed anywhere in the repository tree and consideration must be given to a meaningful directory hierarchy. When a shared container is used, […]

Continue reading about Shared Containers

admin on May 2nd, 2012

DataStage Folder Hierarchy: The DataStage repository is organized in a folder hierarchy, allowing related objects to be grouped together. Folder names can be long, are alpha numeric and can also contain both spaces and underscores. Therefore, directory names are word capitalized and separated by either an underscore or a space Information Server 8 maintains the restriction that […]

Continue reading about DataStage Folder Hierarchy

admin on May 2nd, 2012

Naming Conventions by Object Type: In this section we describe the object type naming conventions. Projects Each DataStage Project is a standalone repository. It might have a one-to-one relationship with an organizations’ project of work. This factor can cause terminology issues especially in teamwork where both business and developers are involved. The name of a DataStage […]

Continue reading about Naming Conventions by Object Type

admin on May 2nd, 2012

Documentation and Metadata Capture: One of the major problems with any development effort, whatever tool you use, is maintaining documentation. Despite best intentions, and often due to time constraints, documentation is often something that is left until later or is inadequately implemented. Establishing a standard method of documentation with examples and enforcing this as part of the […]

Continue reading about Documentation and Metadata Capture

admin on April 27th, 2012

Key Attributes of the Naming Convention: This naming convention is based on the following three-part convention: Subject, Subject Modifier, and Class Word In a DataStage job, there might be multiple stages that correlate to a certain area or task. The naming convention described in the previous section is meant to reflect that logical organization in a […]

Continue reading about Key Attributes of the Naming Convention

admin on April 27th, 2012

Naming Conventions As a graphical development environment, DataStage offers (in certain restrictions) flexibility to developers when naming various objects and components used to build a data flow. By default, the Designer tool assigns default names based on the object type, and the order the item is placed on the design canvas. Though the default names might create […]

Continue reading about Naming Conventions