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.