10.4.31. Row Add Database Name Filter

The rowadddbname filter adds a new
column to every incoming row of data containing the schema name of the
table. This can be used in combination with analytics replication targets
where the information is being written into a single schema, concentrating
data from multiple source databases into a single database. Optionally,
the filter can also add the information as a primary key (required for
some heterogeneous targets), and the hash of the source database name.

Add a hash column, computed using the Java hash value of the
string for the incoming source database name

addkey

boolean

true

Add the information to the primary key data in the THL, in
addition to the column data

fieldname

string

dbname

The name of the database name column that will be added

fieldhashname

string

dbname

The name of the database has name column that will be added

The rowadddbname filter adds a
column to every row of THL processed by the filter. This can be used when
data is being written into a single target schema within an analytics
environment, and where the source database can be used to identify a
customer, project or dataset, and therefore queried within the analytics
platform either specifically or with other datasets.

The filter is able to perform the following modifications to every row of
incoming data:

Add the source database or schema name.

Add a numerical hash value of the string of the source database of
schema name.