Beginners Informatica Data Quality IDQ 9x-Address Doctor transformation tutorial 8

This video covers below:-
--Create a simple Informatica IDQ 9x mapping using key generator transformation for beginners series to generate keys for one or more natural keys
--Showcase the Address Doctor transformation capabilities
--Standardizes Address related fields
--Improves return mails and decrease costs
--Also gives status codes (metadata) related to the address's

---

Closed Caption:

hello and welcome to go eco . com
in this video we will be covering how to
create an address dr. transformation
this transformation is one of the very
important transformation within idq keep
in mind this actress dr. transformation
is not readily available after your ID
QR power center is installed you need a
separate license for address doctor and
a separate install and the configuration
for address doctor within idq so what
this address doctor is all about actress
dr. mainly standardizes your addresses
and so it improves written males and
decrees lot of costs for a company
another great feature about address
doctor is that it gives status codes
like metadata about the particular
address and these are the status chords
which helps you in identifying whether
this particular address is deliverable
or it's not deliverable or it's a valid
address or it's an invalid address one
of the important score is male ability
scores and you can see the different
values of these course like five being
completely confident address that you
will definitely delivered to this
address and 0 being undeliverable so
let's jump right into the address dr.
transformation now so i have already
opened the developer to and I have this
resource which is nothing but have data
from my source table and I just wanted
to run the data viewer to show you the
address data within this source as you
can see this data comes as two rows and
the street is this one and this one and
the city and the zip code
the one thing for address doctor is that
you need to have the country in your
source data because the country is not
specified and this is a United States
address so let me create expression
transformation
shin and we will hardcore the country
there for that let's just pass at least
one in control of expression has to have
one in control and in the properties
here we can simply create one output
port and we can say that as country and
we can put the value of the country as
USA validate ok say now we are all set
to create the transformation or
addressed are the transformation is
called address quality data here is the
address validator transformation as soon
as you highlight this and go to
templates fear you will see basic model
and that once model and for this video
basic model is more than good enough and
he won for most of your use cases basic
model will be good enough so discreet
multi-line hybrid is nothing but
discreet has each and every element in a
separate field and a multi-line can be
lets say a whole address in one line or
two lines and hybrid is nothing but the
combination of discrete or multi-line so
in this case the discrete is already
there
if this would have not been there then
you can always select from here and in
this case these are the fields which has
been selected and then you need to click
this one here at Porto transformation
this is grayed out for now because these
are already in the transformation so
let's see how to add some of the output
elements because that is empty right now
so the outputs are nothing but all these
things in this case what i will do is i
will output the delivery address line 1
and you just add or transformation and
in the last line elements i can simply
add the locality name which is nothing
but the city name postal cord and maybe
province abbreviation which is the
straight name also another important
thing is the status in for which is very
handy
availability score is one of the
important scores you can even get others
as well so let's add that to the port so
once you have the template defined an
address doctor knows what to accept as
input and what to output from the
address
dr. transformation or address validator
transformation
now let's add the columns are linked the
columns here so address one is going to
my street complete at just 2 is going to
my street complete to locality complete
one is nothing but my city and my postal
code is my zip province is my state and
the country is country which I have just
hardcore in here so now let's add
another expression transformation where
I wanted to show my source information
so this is my source cities
I'm not linking address too because I
know within this data set adders to is
actually empty now from my output i will
do the delivery address line 1 and from
last line elements i can simply do all
these three and also from status in for
will do male ability school so now let's
save this and run the data viewer on my
expression one little
now you can see that the output has been
returned and now let's see if we are
seeing any differences if you look at
the first address this is from my source
and this is from address doctor in this
case it has standardized the street name
to st and these standardizations are
based on usps recommendations if you
look at the other address it has not
standardized street to stress tea and
the reason is if you look at the mail
ability score here the first row is 5
which is high confidence address that
they will definitely delivered to this
address
whereas the second line is 0 which means
this is an invalid address so that's why
it has not even touch this address so
this is all about the address
dr. transformation i wanted to show I
don't want to derail this topic from
address doctor and start creating a
target here you're wondering how to
create a target i would recommend to go
and check some of my previous videos
this video was mainly for the address
validator or address dr. transformation
and i hope that you have learned how to
work with address doctor or address
validator transformation
this completes this particular video and
in my next tutorial i would be covering
more idq transformations thanks for
watching this video
check out our website go.com for more
easy