Informatica Data Quality
- Informatica Data Quality 10.4.0
- All Products
[Informatica_DQ_Content]\Rules\Financial_Data_Cleansing
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:
|
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.
|