DataStage migration, down to the detail.

Translate nested expressions, evaluate stage variables in dependency order, apply output constraints and assign values to declared output types. Generate separate accepted and reject streams for configured routing.

• Nested expressions
• Stage variables
• Reject streams

Build a distinct projection for each outgoing link, preserving its selected columns, column order and declared output assignments.

• Column projection
• Multiple outputs

Translate captured field transformations into named target projections and casts so the output schema follows the source design.

• Rename
• Drop
• Cast

Use captured grouping keys and aggregate expressions, including declared decimal and double calculation types. Carry nullable grouping keys and output assignments into the generated calculation.

• Grouping keys
• Decimal precision
• Typed aggregates

Generate rows from captured integer sequence settings and the requested record count. Carry declared output columns into downstream transformations.

• Integer sequences
• Record count

Generate surrogate keys with an explicit starting offset available for configuration and review.

• Generated keys
• Starting offset

Build target joins from explicit input roles and key mappings. Carry selected output columns into the resulting projection.

• Inner / outer joins
• Input roles
• Join keys

Translate ordered reference lookups, equi and range conditions, and configured multirow matching. Model Continue, Drop, Fail and Reject outcomes with accepted and reject output handling.

• Range conditions
• Multiple references
• Outcome routing

Use captured master and update input order, merge keys and output mappings to build the enrichment logic and retain unmatched master rows.

• Master / update roles
• Key mappings

Translate captured dimension keys, change columns and state assignments. Generate insert-only, Type 1 and source-declared Type 2 or mixed transitions with expiry expressions, new dimension versions and downstream resolved keys.

• Business keys
• Type 1 / Type 2
• History lifecycle

Generate the insert-only comparison path from before and after inputs and captured comparison keys.

• Before / after inputs
• Insert detection

Translate typed predicates with explicit null handling. Route rows according to the captured first-match or multiple-match setting, including the configured reject link.

• Typed predicates
• Match mode
• Reject output

Use the captured selector expression and case definitions to generate the corresponding output branches.

• Selector expression
• Output branches

Combine named input branches using the captured mode. Apply branch projections and declared output types, and use captured ordering requirements for sequence and sorted delivery.

• Three funnel modes
• Branch projection
• Output types

Read source sort requirements and carry ordering metadata into target sorting and downstream operations that depend on row order.

• Ascending / descending
• Null placement
• Order metadata

Use duplicate keys, sort keys and partition information to express which row survives. Carry that selection into the downstream output.

• Duplicate keys
• First / last
• Partition information

Emit row logging for the configured fields, keeping the diagnostic step connected to the generated data flow.

• Selected columns
• Row logging

Read comma, tab, pipe and semicolon delimiters with captured quoting, header, null-marker, encoding and file-selection settings. Generate comma-delimited writes with column order, LF or CRLF record endings and the configured header and quote policy.

• Read / write
• File patterns
• Encoding & framing

Translate paired Data Set producers and readers into versioned Delta exchanges. Retain the logical source identity and declared schema across the job boundary.

• Producer / consumer
• Versioned Delta
• Schema continuity

Preserve captured OracleConnector and OracleConnectorPX queries and parameters. Prepare source reads with explicit parameter binding and typed date and timestamp transport.

• Original SQL
• Parameter binding
• Typed source reads

Prepare source-side ABAP extraction using the original SELECT and declared field mappings for data transport into the target flow.

• ABAP SELECT
• RFC adapter
• Source extraction

Invoke child jobs with captured parameter handoff. Use recorded success, warning and failure outcomes to drive the sequence.

• Child runs
• Parameters
• Status branches

Carry the source command into adapter-based execution and return its outcome to the sequence control flow.

• Command adapter
• Execution outcome

Evaluate captured variable expressions in order and make their values available to subsequent sequence activities and conditions.

• Expression order
• Sequence state

Coordinate incoming activities using the captured all or any setting before continuing to the next activity.

• All / any
• Activity dependencies

Translate captured trigger expressions into sequence decisions using activity outcomes and the available sequence context.

• Custom triggers
• Conditional branches

Carry captured numeric bounds or delimited-list values into loop execution, with the iteration value available to the loop body.

• Numeric bounds
• List values
• Iteration state

Route execution into the captured exception-handling path and retain the activity outcome in the sequence record.

• Exception paths
• Outcome context

Apply captured termination behavior, including child-run stop and wait handling. Track execution progress for sequence restart and recovery.

• Stop / wait
• Child-run handling
• Restart & recovery