My Datastage Notes

Transformer Stage

Various functionalities of Transformer Stage:


Generating surrogate key using Transformer

Transformer stage using stripwhitespaces

TRANSFORMER STAGE TO FILTER THE DATA

TRANSFORMER STAGE USING PADSTRING FUNCTION
 
CONCATENATE DATA USING TRANSFORMER STAGE

FIELD FUNCTION IN TRANSFORMER STAGE

TRANSFORMER STAGE WITH SIMPLE EXAMPLE

TRANSFORMER STAGE FOR DEPARTMENT WISE DATA

HOW TO CONVERT ROWS INTO THE COLUMNS IN DATASTAGE

SORT STAGE AND TRANSFORMER STAGE WITH SAMPLE DATA EXAMPLE

FIELD FUNCTION IN TRANSFORMER STAGE WITH EXAMPLE

RIGHT AND LEFT FUNCTIONS IN TRANSFORMER STAGE WITH EXAMPLE

Some other IMportant functions:


How to perform aggregation using a Transformer

Date and time string functions

Null handling functions

Vector function-Transformer

Type conversion functions-Transformer

How to convert a single row into multiple rows ?


Data Stage Transformer Usage Guidelines

 

 

 

 

 

No comments:

Post a Comment

Home
View mobile version
Subscribe to: Posts (Atom)

Pages

  • Home
  • Different Versions
  • All Datastage Stages
  • Configuration File
  • Sequentional_Stage
  • Dataset
  • Transformer Stage
  • Sort Stage
  • Aggregator_Stage
  • Join Stage
  • Lookup_Stage
  • Merge_Stage
  • Filter_Stage
  • Copy Stage
  • Funnel_Stage
  • Column Generator
  • Surrogate_Key_Stage
  • SCD
  • Pivot_Enterprise_Stage
  • Sequence_Activities
  • Datastage Study Material/Interview Questions
  • Datastage Errors and Resolution
  • Datastage Scenarios and solutions
  • Unix Shell Scripting
  • SQL/Database
  • Datawarehousing Concepts

Blog Archive

  • ▼  2018 (11)
    • ▼  July (10)
      • How many ways we can implement scd in Datastage
      • List of Environment Variables in DataStage
      • Slowly changing dimesion
      • Datastage execution process
      • Datastage Tips
      • Complex flat file data load to a table
      • Datastage job control functions
      • DataStage: Join vs Lookup vs Merge
      • DataStage: Loop With Transformer
      • Change in configuration compilation required?
    • ►  June (1)
  • ►  2015 (7)
    • ►  September (4)
    • ►  February (3)
  • ►  2014 (54)
    • ►  October (8)
    • ►  September (40)
    • ►  May (4)
    • ►  February (2)
  • ►  2013 (39)
    • ►  December (1)
    • ►  October (1)
    • ►  June (3)
    • ►  May (6)
    • ►  April (22)
    • ►  March (6)
Manohar. Simple theme. Powered by Blogger.