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