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

Financial Services Financial Data Cleansing Rules

Financial Services 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 Financial Services accelerator:
Name
Description
rule_Account_Status_Validation
Validates the account status. The rule requires account status reference data.
rule_Accrual_Period_Validation
Validates that the start date is earlier than the end date.
rule_Age_For_Account_Validation
Validates the customer age for the account type. The rule uses the age_per_account_infa reference table. You must update the reference table with your own data.
rule_Beta_Coefficient_Validation
Validates that the Beta coefficient string is a number. The rule indicates that the string is a positive number, negative number, zero, or not a number.
rule_BIC_SWIFT_Code_Validation
Validates a Bank Identifier Code (BIC) or Society for Worldwide Interbank Financial Telecommunication (SWIFT) code by pattern recognition and country code validation.
rule_CAN_Transit_Number_Validation
Uses paper and electronic fund transactions to validate the format of a Canadian transit number.
rule_Credit_Card_Expiry_Check
Validates a credit card expiration date. The rule compares the credit card expiration date to the system date and identifies expired dates. The rule accepts a seven character string in the format MM/YYYY.
rule_Credit_Card_Security_Code_Validation
Validates that the credit card security code is a whole number that contains three or four digits.
rule_Currency_Code_Country_Validation
Validates that the currency code is valid for the ISO three-character country code.
rule_Currency_Code_Validation
Validates the currency code. The rule returns "Valid" or "Invalid."
rule_CUSIP_Validation
Validates the format and length of the check digit value. The rule returns a status that describes the validity of the check digit value and a message that explains the status.
rule_Delta_Validation
Validates that the delta value is positive, negative, or zero.
rule_Dividend_Yield_Validation
Validates that the dividend yield string is a number greater than or equal to zero. The rule returns whether the string is a positive number, negative number, zero, or not a number.
rule_EAD_Drawn_Balance_Validation
Validates that the amount listed in the exposure at default (EAD) is not less than the drawn balance. The rule follows the guidelines for EAD calculation by the Financial Services Authority in the United Kingdom.
rule_EAD_Validation
Validates that the exposure at default (EAD) string is a number. The rule returns whether the string is a positive number, negative number, zero, or not a number.
rule_EPS_Validation
Validates that the input is a number greater than or equal to zero.
rule_Ex_Dividend_Date_Validation
Validates that the ex-dividend date and the record date are valid dates and that the ex-dividend date is earlier than the record date. The rule identifies dates with a difference of more than 15 days as not valid. The rule returns the difference in days between the record date and the ex-dividend date.
rule_Gamma_Validation
Validates that the Gamma string is a number. The rule returns whether the string is a positive number, negative number, zero, or not a number.
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_Standardize
Standardizes a United Kingdom bank sort code to the format "NN-NN-NN."
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_Interest_Rate_Within_Range
Validates if the decimal interest rate value is within the specified range. The range is set by the two variable ports in the Expression transformation. The rule returns "True" or "False."
rule_ISIN_Code_Validation
Validates that the input value is an International Securities Identification Number (ISIN). The rule checks the structure of the value and verifies the check digit.
rule_Loan_to_Value_Ratio
Calculates the loan to value ratio, which is the loan amount divided by the property value.
rule_Loss_Given_Default_Validation
Validates that the string is numeric and a positive, negative, or zero value.
rule_Market_Cap_Validation
Validates that the input is a number greater than or equal to zero.
rule_Maturity_Date_Validation
Validates that the maturity date is greater than the system date.
rule_Positive_Close_Price_Value_Validation
Validates that the input is a number greater than zero.
rule_Positive_Coupon_Percent_Validation
Validates that the input is a number greater than zero.
rule_Positive_Last_Price_Value_Validation
Validates that the input is a number greater than zero.
rule_Positive_Open_Price_Validation
Validates that the input is a number greater than zero.
rule_Positive_Volume_Validation
Validates that the input is a number greater than zero.
rule_Price_Earnings_Ratio_Validation
Validates that the price-to-earnings ratio is a positive number in the range of 0 - 100.
rule_Probability_of_Default_Validation
Validates that the probability of default value is numeric and indicates if it is a positive, negative, or zero value. If positive, The rule returns status messages for values in the following ranges:

    < = .1

    > .1 and < = .5

    > .5 and < = 1

    > 1

rule_Rating_Code_Validation
Validates that a rating is in the Standard & Poor's ratings scale, the Moody's ratings scale, or in a user-defined list.
rule_Rating_Date_Validation
Validates that the rating date is one year greater than the system date.
rule_Risk_Weighted_Asset_Validation
Validates that a risk weighted asset is a positive number.
rule_SEDOL_Validation
Validates a Stock Exchange Daily Official List (SEDOL) code by checking its format and check digit.
rule_Stock_Exchange_Validation
Validates most stock exchanges world wide by name and symbol.
rule_USA_Routing_Number_Validation
Validates a standard magnetic ink character recognition line (MICR) formatted routing number. Validates the Associated Federal Reserve Bank, the structure of the input, and the checksum calculation.
rule_Volatility_Validation
Validates that the volatility value is a number greater than or equal to zero.