Data Quality accelerator bundles

Back Next

Cloud Data Quality automation bundle

Use the assets in the automation bundle to perform common data quality tasks and avoid the overhead of a large team to maintain the Data Quality programs. After the Data Quality process completes, you can see the results in a file or a table.

The following table describes the automation bundle assets:

Name	Type	Description
address_street_line_infa	Dictionary	Contains lists that help interpret the street line of addresses.
calendar_month_frm_number_infa	Dictionary	Contains the names of the calendar months and the numerical equivalent for each month. For example, January and 1.
calendar_months_infa	Dictionary	Contains the names of the calendar months.
company_sufx_abrv_infa	Dictionary	Contains company suffix abbreviations.
company_sufx_long_infa	Dictionary	Contains company suffixes.
countries_infa	Dictionary	Contains the names of all the countries globally.
Email_Domain_Name_Infa	Dictionary	Contains domain names for email addresses. For example, .com , .net, and so on.
numbers_special_characters_infa	Dictionary	Contains a list of numbers and special characters including two spaces.
phone_chars_infa	Dictionary	Contains a list of special characters that can be used as part of a phone number.
timezones_infa	Dictionary	Contains a list of all timezones.
US_Can_States_Infa	Dictionary	Contains the name of the states or provinces of the US and Canada.
us_county_infa	Dictionary	Contains a list of the United States counties.
usa_company_names_std_infa	Dictionary	Contains a list of company name standards in the United States.
usa_firstnames_infa	Dictionary	Contains a list of the United States first names.
usa_nicknames_infa	Dictionary	Contains a list of the United States nicknames.
usa_surnames_infa	Dictionary	Contains a list of the United States surnames.
Validate_Big_Integer	Dictionary	Validates if the input is a big integer.
Validate_Calendar_Month	Rule Specification	Validates if the input is a month.
Validate_Calendar_Quarter	Rule Specification	Validates if the input is a month, and returns the quarter.
Validate_Calendar_Year	Rule Specification	Validates a date, and returns a calendar.
Validate_Character	Rule Specification	Validates if the input is an alphabetical or a special character.
Validate_CompanyName	Rule Specification	Validates if the input is a company name.
Validate_Country	Rule Specification	Validates if the input country is valid.
Validate_Currency	Rule Specification	Validates the input as currency Monetary amount for the price list. isNullable:true maximumValue:100000000000000 minimumValue:0 is.dataFormat.numeric.shaped
Validate_Date_Creation	Rule Specification	Validates if the input is a date and returns the date in the DD-MM-YYYY format.
Validate_Date_Measurement	Rule Specification	Compares the input date to the current time stamp. Also displays the date and time when the record was migrated. isNullable : true Traits: is.dataFormat.date means.measurement.date is.dataFormat.time means.measurement.time means.measurement.date.creation
Validate_EmailAddress	Rule Specification	Validates if the input is an email address.
Validate_FirstName	Rule Specification	Validates if the input is a first name.
Validate_Integer	Rule Specification	Validates if the input is an integer. maximumValue: 2147483647 minimumValue: 2147483648 Is_nullable: 'True'
Validate_LastName	Rule Specification	Validates if the input is a last name.
Validate_Latitude	Rule Specification	Validates if the input is a valid latitude.
Validate_Longitude	Rule Specification	Validates if the input is a valid longitude.
Validate_MiddleName	Rule Specification	Validates if the input is a middle name.
Validate_Month_frm_Quarter	Rule Specification	Validates the month from a date and returns the name of the month.
Validate_NickName	Rule Specification	Validates if the input is a nickname.
Validate_Phone_Fax	Rule Specification	Validates if the given input is a telephone or a fax number.
Validate_Small_Integer	Rule Specification	Validates if the input string is a small integer.
Validate_Street_Line	Rule Specification	Validates the street line of an address.
Validate_Text	Rule Specification	Validates if the input is an alphabetical text.
Validate_TickerSymbol	Rule Specification	Validates if the input is a valid ticker symbol.
Validate_Timezone	Rule Specification	Validates a given timezone.
Validate_URL	Rule Specification	Validates if the given input is a URL.
Validate_US_Canada_StateName	Rule Specification	Validates if the input is United States state or Canada state or province name.
Validate_USCounty	Rule Specification	Validates if the input is a United States county.