Accelerator Guide

Back Next

United Kingdom Financial Data Cleansing Rules

Use the financial data cleansing rules to parse, standardize, and validate financial data.

Find the financial data cleansing rules in the following repository location:

[Informatica_DQ_Content]\Rules\Financial_Data_Cleansing

The following table describes the financial data cleansing rules in the United Kingdom accelerator:

Name	Description
rule_GBR_Bank_Account_Parse	Parses eight-digit numeric strings as United Kingdom bank account numbers.
rule_GBR_Bank_Account_Validation	Validates United Kingdom bank account numbers. The rule returns codes that indicate whether the input is numeric and whether it is the correct number of digits.
rule_GBR_Bank_Sort_Code_Parse	Parses six-digit numeric strings as United Kingdom bank sort codes. The rule parses strings of numbers in the following formats: Consecutive numbers (999999) Numbers delimited with a dash (99-99-99)
rule_GBR_Bank_Sort_Code_Validation	Validates the format and length of United Kingdom bank sort codes that are standardized to the dash-delimited format (99-99-99). The rule returns a Status port that describes the validity of the sort code and a Validation Note port that explains the status. If the sort code prefix matches a known assignment for a United Kingdom bank, the Validation Note port includes the bank name.
rule_GBR_Bank_Sort_Code_Standardize	Standardizes a United Kingdom bank sort code to the format "NN-NN-NN."