The Runtime Column Propagation (RCP) is OFF by default.
With the RCP is trurned on in DataStage:
Source data columns are read and flow through a stage or stages without explicitly defined in stage
Explicit mapping is not required from Source to the Target columns in a stage
Also, DataStage does not enforce or validate any column mapping during design/compile time.
Input columns are mapped...
Thursday, February 11, 2016
Datastage Job Sequences
Job Sequences:
Contain control information, for ex:, specify different courses of action to take depending on where a job in sequence succeeds or fails.
Specify a sequence of server or parallel jobs to run.
Can be scheduled and run using DataStage Director.
Appears in DataStage...
Tuesday, January 26, 2016
Keyed & Keyless Partitions in IBM DataStage
This post is about the IBM DataStage Partition methods:
Keyless
Partitioning
Rows distributed independently of data
values
Keyed
Partitioning
Rows distributed based on values in
specified keys
Same:
Existing Partition
is not altered
Round Robin:
Rows are evenly
processed among partitions
Random:
a
row is assigned based on random algorithm
Entire:
Each...
Monday, January 25, 2016
Database Cursors?
In this post I am going to discuss about Database cursor on a high level.
Database Cursors:
Cursors is a PL/SQL construct that allows us to name these work areas, to access and traverse the information stored in the database object.
Database Cursor types:
There are two cursor types, namely
-Implicit Cursor
-Explicit Cursor
Implicit Database Cursor:
Declared by PL/SQL...
Database Triggers?
In this post I am going to mention details of Database Triggers on a high level.
Database Triggers:
Is a block of statements that are implicitly fired by a database when INSERT, UPDATE, DELETE statements issued against given table.
Triggers are stored in a database separately from their...
The Database rowid and rownum pseudo columns
The Database rowid and rownum are the important pseudo columns that can be used and helpful in query writing.
Database rowid:
It is automatically generated unique id of a row and it is generated at a time of row inserts in a table
It is a physical address of the rows.
A rowid is permanent
A rowid is 16-bit hexadecimal
A rowid gives address of rows or records
A rowid is the fastest means...
DataStage Server Side Tracing
Server Side Tracing helps trace activity on Datastage server to help diagnose project problems. Server
tracing to be disabled by default. When you enable it, information about server
activity is recorded for any clients that subsequently attach to the project.
This information is written...
Subscribe to:
Posts (Atom)
