Advanced topics

The following topics help to extend your knowledge of PDI beyond basic setup and use:

• Understanding PDI data types and field metadata

  Learn how data is treated in PDI to understand data type and field metadata behaviors in transformations and jobs.

• PDI Run Modifiers

  Use arguments, parameters, or variables to modify how you run transformation and jobs.

• Reuse Transformation Flows with Mapping Steps

  Learn how to map commonly used steps into their own steps.

• Use Checkpoints to Restart Jobs

  Learn how to restart a job at the last checkpoint before an error occurred.

• Use the SQL Editor

  Learn how to generate SQL statements.

• Use the Database Explorer

  Explore configured database connections.

• Transactional Databases and Job Rollback

  Implement job rollback by making the transformation or job databases transactional.

• Interact with Web Services

  Determine what must occur if your transformation or job interacts with a web service.