Added by Matt Casters, last edited by Matt Casters on Apr 20, 2012

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

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