Using Wildcards in Routing Rules - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

You can use a wildcard character (*) to define routing rules when more than one Teradata system is managed by Unity. Use of a wildcard creates a Preferred routing rule because it automatically includes multiple systems and a preferred order for Read/Writes and Failover.

You can use a wildcard character (*) for the userid and accountstring in user mappings. Unity recognizes four types of userid pattern matching and four types of accountstring pattern matching.
Pattern Description Example
Exact match Exact name match and exact account string match are always first choice in mappings. patriciadarrell syssd1
Trailing wildcard match Field must start with the pattern. pat* syssd*
Leading wildcard match Field must end with the pattern. *darrell *sd1
You cannot use a wildcard character (*) within a string. Use wildcards only at the beginning or end of the string.
When using wildcards, be careful with overlapping wildcards. A userid and accountstring could match multiple entries in the routing file. Unity uses the user mapping with the lowest ordinal value that matches the userid and accountstring.