Call Us: (+1) 512.434.0233
email

  • Home
  • Services
    • Talend Data Integration
    • Talend Big Data
    • Talend Integration Cloud
    • Talend Data Quality
    • Talend MDM
    • Talend ESB
  • About
  • Management
  • Clients
  • Contact
  • Talend Tutorials



Street Address Standardization

Our client maintained a database of company information including street address data which was aggregated from a variety of sources. In order to reduce the number of duplicate entries upon loading, we built an integrated solution in Talend Open Studio to transform each street address into a standardized version based upon USPS specifications.


 


This job contains the following features:

  • Connection to Oracle database
  • Extraction of street address data from loading table
  • Custom java string manipulation of address data
  • Look-up and replace of particular stop words in company and address data utilizing a particular specified order
  • Loading of standardized data into review table

Samples of our work

  • Complex XML parsing
  • Data warehouse loading
  • Dynamic Hadoop Load
  • Ftp extraction and loading
  • Street address standardization

About Us

ETL Advisors is a leading data integration consulting firm, specializing in Talend Enterprise Platform and Talend Open Studio development. Our expert consultants have over 8 years direct Talend development experience in Talend Data Integration, Data Quality, MDM, ESB & Big Data products.


Popular Tutorials

Iterate to load multiple excel files
29 Comments
Extract from XML to Flat Files
8 Comments
Using tREST and JSON components to access API data
7 Comments

Contact





  • About
  • Clients
  • Contact Us
  • Home
  • Management
  • Services
    • Talend Big Data
    • Talend Data Integration
    • Talend Data Quality
    • Talend ESB
    • Talend Integration Cloud
    • Talend MDM
  • Talend Tutorials
  • Work Samples
    • Call Access Macro with Talend
    • Complex XML Parsing
    • Data Warehouse Loading
    • Dynamic Hadoop Load
    • Ftp Extraction and Loading
    • Street Address Standardization

+1.512.434.0233 | info@etladvisors.com | 809 South Lamar Blvd Suite F, Austin, TX, 78704
Copyright 2018, ETL Advisors