Other commonly used transformation steps

PDI Transformation steps are documented in Documentation

• INPUT: Generate Rows, Data Grid, Get Data from XML, CSV File Input, Fixed File Input

• OUTPUT: XML Output

• TRANSFORM: Split Fields, Calculator, Add Constants, Add Sequence, Replacing Strings, Split Fields, Sort Rows, String Operations, Strings Cut

• SCRIPTING: User Defined Java Class, Modified Java Script Value, User Defined Java Expression

• FLOW: Abort, Append Streams, Block this step until steps finish, Blocking Step, Detect Empty Stream, Dummy, ETL Metadata Injection, Filter Rows, Identify Last Row in a Stream, Java Filter, Job Executor, Prioritize Streams, Single Threader, Switch/Case, Transformation Executor

• LOOKUP

• JOINS: Join Rows, Merge Join

• JOB: Get Variables, Set Variables