informatica.infacore.functions.dq_functions.DataQualityFunctions.validate_ssn

DataQualityFunctions.validate_ssn(src_data_object: DataObject, ssn_col_name: str)

Parses a United States SSN pattern from a larger string of text. This function parses SSNs with dashes or without dashes. It also formats and validates the SSN.

Parameters:

  • src_data_object (DataObject) – The object name for the source DataObject class.

  • ssn_col_name (str) – Column name corresponding to the SSN number.

Returns:

Validation values “Valid” or “Invalid” for the SSN number in columnar representation.

Return type:

table

Example

>>> import informatica.infacore as ic
>>> dq_obj = ic.DataQualityFunctions()
>>> dq_obj.validate_ssn(src_data_obj, ssn_col_name)