Address Doctor/Validator Transformation




How To Configure

Prerequisites


  • Access to the Admin Console to create services
  • Address Doctor Reference  Files(*.MD Files)
  • Address Doctor License Key
Steps


  1. Unzip any Zipped Reference Data  -Address Doctor reference files looks like DB5_USA_5B1_140401
  2. Copy Unzipped reference files on to server Directory.
  3. Create the Content Management Service (CMS) in the Admin Console.
  4. Provide Reference Data file directory location under CMS properties.
  5. Provide Address Doctor License Key under CMS Properties. note- sperate with a comma if you have more than 1 key
  6. Specify preloading options under CMS (usually all)
  7. Use the rest of the properties as Default or Blank
  8. Restart CMS and DIS (DIS) services. 



Characteristics


  • You need a separate license
  • It's not installed Out of Box and needs to be installed and configured in IDQ separately.
  • Is used to Standardize Address.
  • Improves return mails and thus decreases cost.
  • Give status code(metadata) about that particular address.
    • the status code helps you to identify if an address is deliverable or not or its valid or invalid.
  • It Provides Mailability Scores
    • 5 - Completely Confident
    • 4 - Almost Certain
    • 3 - Should be fine
    • 2 - Fair Chance
    • 1 - Risky
    • 0 - Undeliverable
  • It needs to have a country in your incoming address.

Templates


  • Basic Model
    • Discrete
      • Has all address Attributes in separate columns
    • Multiline
      • Has multiple attributes in one column.
    • Hybrid
      • Mix of above
    • Output Elements
      • Address Elements
        • Locality Name
        • Postal Code
        • Province Name
      • Last Line Elements
      • GeoCoding
      • US Specific
      • Canada Specific
      • France Specific
      • Australia Specific
      • NewZeland Specific 
      • UK Supplementary
      • StatusInfo

  • Advance Model



Comments

Post a Comment

Popular posts from this blog

IDQ - Data Profiling

To Analyze and Understand the Data. It is done using IDQ Analyst Web Client. Helps you understand the Data Quality and configure the Trust values accordingly in Informatica MDM Data Quality and Profiling Use the data quality capabilities in the Developer tool to analyze the content and structure of your data. You can enhance the data in ways that meet your business needs. Use the Developer tool to design and run processes that achieve the following objectives: Profile data. Profiling reveals the content and structure of your data. Profiling is a key step in any data project as it can identify strengths and weaknesses in your data and help you define your project plan. Create scorecards to review data quality. A scorecard is a graphical representation of the quality measurements in a profile. Standardize data values. Standardize data to remove errors and inconsistencies that you find when you run a profile. You can standardize variations in punctuation, formatting, an...
Read more

Labeler and Standardizer Transformation

Both are Used for Data Cleansing and Standardization for Addresses, Company Names(like LTD for limited, TAS  Trading As,). Labeler Characteristics Labels Different Incoming values e.g. #$^& as Symbols or S 017242 as 99999 Properties/Strategies Label using Reference Table Label Using Character Set. Standardizer Characteristics Used for Standardizing the Data e.g. AVE or AVE or AVNUE to AVENUE Properties/Strategies Offers Removal of Spaces. Label Using Character Set. Remove Reference Table Match Remove Custome String Replace Reference Table Matches with Valid Values Replace Reference Table Matches with Custome Values Replace Custome Strings.
Read more