The data pattern search template search for patterns across all fields and returns a concatenated list of fields that matches the respective pattern. The pattern search makes use of the REGEX (Regular Expression) function.
The Data Pattern Search Template can be used to search for patterns such as emails, phone numbers, dates, and more. The Template uses a REGEX (Regular Expression) matching algorithm to search for the data. The template can be used to identify relevant fields in unknown data sources that have the specific data patterns you are looking for. Users can leverage this template for a variety of use cases such as:
Template Mapping in Informatica Cloud Template Designer
Click to view larger image