Best Practices using tMelissaData component

Anonymous — Sat, 16 Nov 2024 06:35:07 GMT

URL: http://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

Re: Best Practices using tMelissaData component

scott3 — Fri, 22 Feb 2019 16:48:38 GMT

It worked, great post!

topic Re: Best Practices using tMelissaData component in Talend Studio

Best Practices using tMelissaData component

Re: Best Practices using tMelissaData component