Best Practices using tMelissaData component

Highlighted
Eight Stars

Best Practices using tMelissaData component

 

URLhttp://wiki.melissadata.com/index.php?title=Result_Codes

 

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")

a)AE

b)AS

c)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

melissa1.PNGmelissa2.PNGmelissa3.PNG

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

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now