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
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is deployment group?
Explian the Process of deployment groups in informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Sequence generator, when you move from develoment to production how will you reset
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Define update strategy?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How we can create indexes after completing the loan process?
What is the difference between informatica 7.0 and 8.0?
Enlist the differences between database and data warehouse.
Can informatica load heterogeneous targets from heterogeneous sources?
What can we do to improve the performance of informatica aggregator transformation?
Is it possible to create multiple domains on a single Informatica server?