Using Alternatives anchor to process variability in input data for same data holder

This is a Short tutorial on Using Alternatives anchor to process variability in input data for same data holder with case study and coverage of the provided sample projects for Data Transformation developers

---

Closed Caption:

hello and welcome to another edition
Informatica b2b data transformation
videos I'm gonna be
introducing something called into
alternatives anchor
the gender for this video is to
basically go through the DT project in
the samples directory
where we'll get a basic understanding
work alternatives mean
and secondly we're going to any example
or a real-life case
implementation where we'll have two
different input files
that will populate the same and data
holders
and use different group so it's
important to understand
following concepts input file
variability
and then how you set up the content
exact you've created the markers
and these are just some other
elements are gonna go through today
let's quickly go into the
data transmission studio this is the
alternatives
file and you can get it in the following
location:
clients DTE samples project alternatives
but this is a lot I'll going to allow us
to do to process the two different
groups
the first group is one that will look
for this last year
in the form of a marker and these
content tax will be the ones world there
will be setting
data holders so when we run this
we're basically going to get a
standardized Exxon on this case will be
three different
data records Ron
terrorist parser check out the output
so Danny mark and you see everything's
captured
properly it would be nice if the
there's jan had been turned into 01 but
in this case
we're just trying to show you the basic
structure is basically having
two different groups and Ernie and
making sure that each has a
content markers as you can see here
to now I wanna go through the real-life
scenario
and that is a single test
index script and what this will do is a
it will be looking for the area between
the index information and column
information and it will process two
different groups
two different groups will have two
different files
number files and recover that right now
so
there'll be one where we will have
actual index information underneath here
so this is the index information star
and this is that
the clothes we're basically going to try
to go in here and get these values here
this is the description and this these
are the actual values
in the notes example
all we have here is just the span
tag with the class Anne calls
and nothing else it's completely anti
okay database creep explanations
so what we have here
when we run this basic example is that
we have
no the first choice when it's looking
for classy calls an A
and then it will have this content
marker
which will allow MT values so
I'm gonna write your this'll be
successful but I'm after then we're
sorry that
different variables variables
test in Dec so you can see it's
populated somebody's
did it data's that you sell in the are
known for
you see there's two index types the
index and an index
one you can actually go and look at the
actual example as well
Asus
this line right here so
what happens when we mess
we don't actually we make this optional
it's important to recover this because
in this particular scenario customer had
made this auction all
we make this optional what ends up
happening since we
allow and the values as we and up with
and I'll put that has
nothing in here so you know index
information where things should be here
but there's nothing here nothing's been
populated
so it's really important that you keep
things your first group not ever use
optional and then in the content marker
secondly what I'm going to cover the
important to getting a positive value
years and this case it's the span marker
cuz
if you don't have any this that's just
me
sniping
it'll end up happening is everything we
get Ron Isley put into the index type
here
so in this case what happens up
happening is that there is concern no
markers
you can elect and you have to assign
values here
everything we get assigned to the index
value time
I'm gonna set everything back to normal
will cover the second group so in the
second group we're gonna be looking for
enabled and we're gonna be parsing
things as the normal way are
only thing that our channels as European
group
this this is where the data is for those
particular I am here
I'm going to be putting up this sample
as par
video as well so you can run this
through your cell
there's the other while
when we use the other
situate other item here we'll get
different results
and the current out with that extra mile
so we return this to be to the regular
I don't you see a house maybe in
document id: those changes to notes in
this war
populate the first group an alternative
thinker
UCL biscuits I played in an A is a value
as it is in the first group appeared for
index type see that
any Sachse within the span
missus
notes index as
what's in the span this value here
said I I workers you to use
documentation
is in the studio here
are you need to do is type in the words
alternatives
hell julie night here
it a transformational table our search
so we look to hear from you
so please email us at support videos and
if America to call more followers on
Twitter
thank you have a good day by now