hw to load this give the mapping?
cty state o/p
c1 s1 c1
c1 s2 s1
c1 s1 c1
c2 s3 s2
c3 s4 c1
c3 s2 s1
c2
s3
c3
s4
c3
s2
2 columns should be loaded to one column in target table?
Answer Posted / balaramesh
first create one normalizer transformation ,double click on
it ,select normalizer tab create column(column name is
cityandstate).set 2 in occurs field and datatype is
string ,next click ok. then automaticaly two input ports
(cityandstate,cityandstate)and threee out pouts
(cityandstate,gk_cityandstate,gcid_cityandstate) are
created.then set city is one inputport(cityandstate) and
state is another input port(cityandstate).set citystate
(outputport) to target table.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is target load order?
What is option by which we can run all the sessions in a batch simultaneously?
How do you convert single row from source into three rows into target?
What are the transformations that are not supported in mapplet?
can anyone explain me about retail domain project in informatica?
What is the maplet?
Explain the etl program with few examples.
How to extract the informatica rejected data?
what is unit testing?tell me proceedure
What the difference is between a database, a data warehouse and a data mart?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What's the layout of parameter file (what does a parameter file contain?)?
How do you load only null records into target?
What is blocking transformation?