Table of Contents

Search

  1. Preface
  2. Introduction to Accelerators
  3. Core Accelerator
  4. Data Domains Accelerator
  5. Australia/New Zealand Accelerator
  6. BCBS 239/CCAR Accelerator
  7. Brazil Accelerator
  8. Financial Services Accelerator
  9. France Accelerator
  10. Germany Accelerator
  11. India Accelerator
  12. Italy Accelerator
  13. Portugal Accelerator
  14. Spain Accelerator
  15. United Kingdom Accelerator
  16. U.S./Canada Accelerator

Accelerator Guide

Accelerator Guide

Column Name Rules in the Data Domains Accelerator

Column Name Rules in the Data Domains Accelerator

Use the data domain column name rules to identify data columns with names that match the column name logic that the rules define. Each rule uses one or more regular expressions to search for common strings that the column name might include.
For example, the rule
dataDomain_MetaDataRule_BIC_SWIFTCode
contains a Labeler transformation that searches with the following regular expressions:
^*[iI][sS][oO].*.[9][3][6][2].*$ ^*[sS][wW][iI][fF][tT]*[bB][iI][cC]$ ^*{bB][iI][cC].*[cC][oO][dD][eE].*$
The column name rules analyze the characters in the column names. The column name rules do not analyze the data values in the columns.
You can find the column name rules in the following repository location:
[Informatica_DQ_Content]\Domain_Discovery\MetaData_Rules
The following table describes the column name rules in the Data Domains accelerator:
Name
Description
dataDomain_MetaDataRule_ABARoutingNumber
Searches for names that can describe a column of American Banking Association routing numbers.
dataDomain_MetaDataRule_AccountNumber
Searches for names that can describe a column of account numbers.
dataDomain_MetaDataRule_AccountStatus
Searches for names that can describe a column of account status information.
dataDomain_MetaDataRule_Address
Searches for names that can describe a column of address information.
dataDomain_MetaDataRule_AdmissionDate
Searches for names that can describe a column of admission date information.
dataDomain_MetaDataRule_Age
Searches for names that can describe a column of age or date of birth information.
dataDomain_MetaDataRule_BankAccount
Searches for names that can describe a column of bank account information.
dataDomain_MetaDataRule_BIC_SwiftCode
Searches for names that can describe a column of Business Identifier Codes. Business Identifier Codes are also called SWIFT codes and ISO 9362 codes.
dataDomain_MetaDataRule_BirthDay
Searches for names that can describe a column of date of birth or birthday information.
dataDomain_MetaDataRule_BirthPlace
Searches for names that can describe a column of place or location of birth information.
dataDomain_MetaDataRule_CertificateLicenseNumber
Searches for names that can describe a column of certificate license number information.
dataDomain_MetaDataRule_City
Searches for names that can describe a column of city information.
dataDomain_MetaDataRule_CompanyName
Searches for names that can describe a column of company name information.
dataDomain_MetaDataRule_Computer_Address
Searches for names that can describe a column of machine or MAC address data.
dataDomain_MetaDataRule_Country
Searches for names that can describe a column of country information, including ISO country code information.
dataDomain_MetaDataRule_CountryCode_Phone
Searches for names that can describe a column of telephone country codes.
dataDomain_MetaDataRule_County
Searches for names that can describe a column of county information.
dataDomain_MetaDataRule_CreditCardNumber
Searches for names that can describe a column of credit card numbers.
dataDomain_MetaDataRule_CreditCardTrack1FormatB
Searches for names that can describe a column of track 1 format B information from a credit card.
dataDomain_MetaDataRule_Currency
Searches for names that can describe a column of currency information.
dataDomain_MetaDataRule_DeviceSerialNumber
Searches for names that can describe a column of device number or serial number information.
dataDomain_MetaDataRule_DischargeDate
Searches for names that can describe a column of discharge date information.
dataDomain_MetaDataRule_DrivingLicenseNumber
Searches for names that can describe a column of drivers license information.
dataDomain_MetaDataRule_Email
Searches for names that can describe a column of email information.
dataDomain_MetaDataRule_ExpirationDate
Searches for names that can describe a column of expiration date information, for example expiration date information for credit cards.
dataDomain_MetaDataRule_FirstName
Searches for names that can describe a column of first name information.
dataDomain_MetaDataRule_FullName
Searches for names that can describe a column of full name information.
dataDomain_MetaDataRule_Gender
Searches for names that can describe a column of gender information.
dataDomain_MetaDataRule_Grade
Searches for names that can describe a column of grade information.
dataDomain_MetaDataRule_HealthCareBeneficiaryNumber
Searches for names that can describe a column of health care beneficiary numbers.
dataDomain_MetaDataRule_Height
Searches for names that can describe a column of height information.
dataDomain_MetaDataRule_Hostname
Searches for names that can describe a column of computer host name information.
dataDomain_MetaDataRule_IBAN
Searches for names that can describe a column of International Bank Account Numbers.
dataDomain_MetaDataRule_ICD_10
Searches for names that can describe a column of values from the tenth revision of the International Statistical Classification of Diseases and Related Health Problems.
dataDomain_MetaDataRule_ICD_9
Searches for names that can describe a column of values from the ninth revision of the International Statistical Classification of Diseases and Related Health Problems.
dataDomain_MetaDataRule_IPAddress
Searches for names that can describe a column of computer IP address information.
dataDomain_MetaDataRule_ISBN
Searches for names that can describe a column of International Standard Book Numbers.
dataDomain_MetaDataRule_ITIN_USA
Searches for names that can describe a column of Individual Taxpayer Identification Numbers.
dataDomain_MetaDataRule_JobPosition
Searches for names that can describe a column of job title, position, or designation information.
dataDomain_MetaDataRule_LastName
Searches for names that can describe a column of last name information.
dataDomain_MetaDataRule_Latitude
Searches for names that can describe a column of latitude information.
dataDomain_MetaDataRule_LatitudeLongitude
Searches for names that can describe a column of latitude, longitude, or geocoordinate information.
dataDomain_MetaDataRule_Longitude
Searches for names that can describe a column of longitude information.
dataDomain_MetaDataRule_MaidenName
Searches for names that can describe a column of maiden name information.
dataDomain_MetaDataRule_MiddleName
Searches for names that can describe a column of middle name information.
dataDomain_MetaDataRule_NationalId
Searches for names that can describe a column of national identity numbers.
dataDomain_MetaDataRule_NDC_USA
Searches for names that can describe a column of National Drug Code information
dataDomain_MetaDataRule_NPI_USA
Searches for names that can describe a column of National Provider Identifier numbers.
dataDomain_MetaDataRule_Passport
Searches for names that can describe a column of passport information.
dataDomain_MetaDataRule_PhoneNumber
Searches for names that can describe a column of telephone numbers or fax numbers.
dataDomain_MetaDataRule_Quantity
Searches for names that can describe a column of quantity information.
dataDomain_MetaDataRule_Race
Searches for names that can describe a column of race or color information.
dataDomain_MetaDataRule_Religion
Searches for names that can describe a column of information about religion, faith, or belief.
dataDomain_MetaDataRule_Salary
Searches for names that can describe a column of salary, wages, or compensation information.
dataDomain_MetaDataRule_SSN
Searches for names that can describe a column of Social Security numbers.
dataDomain_MetaDataRule_State
Searches for names that can describe a column of United States state information.
dataDomain_MetaDataRule_Street
Searches for names that can describe a column of street address information.
dataDomain_MetaDataRule_UniqueIdentifyingNumber
Searches for names that can describe a column of unique identification numbers.
dataDomain_MetaDataRule_UPC_EAN
Searches for names that can describe a column of Universal Product Codes or European Article Numbers.
dataDomain_MetaDataRule_URL
Searches for names that can describe a column of Uniform Resource Locator or web address information.
dataDomain_MetaDataRule_VehicleRegPlateNumber
Searches for names that can describe a column of vehicle registration or vehicle license plate numbers.
dataDomain_MetaDataRule_Weight
Searches for names that can describe a column of weight information.
dataDomain_MetaDataRule_ZipCode
Searches for names that can describe a column of ZIP Codes.