Best Practices using tMelissaData component

Eight Stars

Best Practices using tMelissaData component




we have result Codes for Melissa and Description for every codes in detail

After validating the given source of addresses through Melissa data component

The data is Loaded to staging if the result code column has 'AS01' otherwise we will be sending it to Stewards to take a look at the data.

We have column RESULTS_CODE , which will have codes. (Description for every codes in detail)


IN  RESULTS_CODE column you will find different codes like "AS", "AE" ,"AC""


For Data Stewards team

Please look at the data and column RESULTS_CODE where  you can find the codes to rectify the address

Priorities to rectify addresses (From the column RESULTS_CODE you will find different codes like "AS", "AE" ,"AC")





With The melissa Data component we can leverage the codes and populate the clear message in the tables by using tmap expression, so it will help the business clearly , whether with which courier sevices the Address is deliverable, There are some address which has only usps deliverable and some address will be delivered by all courier services, and also we populate whether the address is occupied or not.


Please look below for tmap expression


Warm Regards,
Please don't forget to give Kudos if it resolves issue, and if you think its Apt you can also mark its as solution.
Four Stars

Re: Best Practices using tMelissaData component

It worked, great post!

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences


Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now