Managing transformations and jobs

Managing transformations and jobs includes managing the files for them inside Pipeline Designer, managing their connections, and performing tasks that are common to both transformations and jobs.

• Manage transformations and jobs

  Manage transformations and jobs on the Pipeline Designer's main page. Available actions include marking transformations and jobs as favorites, downloading them as files, creating duplicates, moving them to different folders or to the trash, renaming them, and viewing their details.

• Manage connections for transformations and jobs

  While creating or editing a transformation or job, you can edit database connections that are used by your transformations and jobs.

• Edit a transformation or job

  Edit an existing transformation or job to rename it, add new steps, edit steps, configure hops, edit properties, reset it, or save it in a different location.

• Use the SQL Editor

  The SQL Editor is good tool to use when you must execute standard SQL commands for tasks such as creating tables, dropping indexes, and modifying fields.

• Use notes on the canvas

  While creating or editing a transformation or job, you can add notes to the canvas to help you and others understand the structure, design decisions, business rules, dependencies, and other aspects of your transformations and jobs.

• Run modifiers

  Run modifiers include parameters, variables, and arguments, which you can use to modify how you run transformations and jobs.

• Export a transformation or job

  Export transformations and jobs to save backup copies, migrate them to other systems, share them with other users, or use them in other tools. You can export a transformation as a .ktr file or a job as a .kjb files.

• Stop transformations and jobs

  There are two different methods you can use to stop a transformation or job running in the Pipeline Designer. The method you use depends on the processing requirements of your ETL task.