Get repository names

This step lists detailed information about transformations and/or jobs in a repository.

A transformation that is executed while being connected to the repository can query the repository and see which transformations and jobs there are stored in which directory.

Options

• Step name: the unique name of the transformation step
• Directory list: the list of queries to perform in the repository
  • directory: the directory to search
  • Name RegEx: the regular expression to match object names
  • Exclude Name RegEx: the regular expression to exclude object names
  • Include subfolders: specify whether or not you want to search sub-folders of the specified directory
• Selected object types: select if you want to list transformations, jobs or both
• Include rownum in output? Enable this option if you want to see a row number in the output of this step
• Rownum field name: the name of the output field for the row number

Output fields

• object: the full name of the object (/dwh/sales/Main Job)
• directory: the directory of the object (/dwh/sales)
• name: the name of the transformation or job (Main Job)
• object_type: the type: JOB or TRANSFORMATION
• object_id: the internal repository object ID.  This is the filename for file repositories, an unique integer for database repositories and a UUID for the enterprise repository
• modified by: the user that last modified the object (when available)
• modified date: the date of last modification
• description: the description of the object
• rownr: optional row number