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