Batch Header Attributes

Batch header attributes are attributes in batch headers that you can use in pipeline logic.

Pipelines with a database-vendor-specific JDBC origin, such as the MySQL JDBC Table or Oracle JDBC Table origin, contain a batch header. In the header, these origins set the jdbc.table attribute, which stores the name of the table that the origin reads for the batch. When the origin reads from multiple tables, you can use the attribute to determine the origin's data source for a batch.

You can use batch functions to return the value of a batch header attribute. For example, you might want the File destination to write data in directories named after the table where the data originated. To write to the /Transformer/output/<table name> directory in your local file system, include the following expression in the Directory Path property: