Starting The ETL Designer

admin on June 4th, 2015

Data transformation and movement is the process by which source data is selected, converted, and mapped to the format required by targeted systems. The process manipulates data to bring it into compliance with business, domain, and integrity rules and with other data in the target environment. Transformation can take some of the following forms: Aggregation […]

Continue reading about Data transformation

admin on June 4th, 2015

In its simplest form, IBM InfoSphere DataStage performs data transformation and movement from source systems to target systems in batch and in real time. The data sources might include indexed files, sequential files, relational databases, archives, external data sources, enterprise applications, and message queues. DataStage manages data that arrives and data that is received on […]

Continue reading about IBM InfoSphere DataStage

The Transformer branch allows you to specify colors used in the Transformer editor. Selected column highlight colors and relationship colors are set by altering the Windows Active title bar color from the Windows Control Panel.

Continue reading about Specifying Designer Options – Transformer Branch

admin on May 11th, 2010

The Prompting branch gives access to pages which determine the level of prompting displayed when you perform various operations in the Designer. There are two pages: General and Confirmation. Scroll down this page for details of all of them. General This page determines various prompting actions for jobs. Confirmation This page has options for specifying […]

Continue reading about Specifying Designer Options – Prompting Branch

admin on May 11th, 2010

The Printer branch allows you to specify the printing orientation. When you choose File > Print, the default printing orientation is determined by the setting on this page. You can choose portrait or landscape orientation. To use portrait, select the Portrait orientation check box. The default setting for this option is cleared, i.e., landscape orientation […]

Continue reading about Specifying Designer Options – Printing Branch

This allows you to specify which column definition items are preserved when you merge column meta data. All the items are selected by default.

Continue reading about Specifying Designer Options – Meta Data Branch

admin on May 7th, 2010

The Default branch of the Designer options tree gives access to two pages, General and Mainframe. Scroll down this page for details of both. General The General page determines how the DataStage Designer behaves when started. Mainframe This page allows you to specify options that apply to mainframe jobs only.

Continue reading about Specifying Designer Options – Default Branch

Specifying Designer Options – Appearance Branch: The Appearance options branch lets you control the appearance of the DataStage Designer. It gives access to four pages: General, Repository Tree, Palette, and Graphical Performance Monitor. Scroll down this page for details of all of these. General The General page decides the appearance of the background, stages, and […]

Continue reading about Specifying Designer Options – Appearance Branch

admin on May 7th, 2010

Specifying Designer Options: You can specify default display settings and the level of prompting used when the Designer is started. To specify the Designer options, choose Tools > Options… . The Options dialog box appears. The dialog box has a tree in the left pane. This contains four branches, each giving access to pages containing […]

Continue reading about Specifying Designer Options

admin on May 6th, 2010

DataStage Designer Window: The DataStage Designer window appears when you start the Designer. The DataStage Designer is a graphical design tool used by developers to design and develop a DataStage job. By default, DataStage initially starts with no jobs open. You can choose to create a new job as follows: The DataStage Designer window appears […]

Continue reading about DataStage Designer Window