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?
- 1 Answers
- 6720 Views
- Wipro, I also Faced
- E-Mail Answers
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
Is it possible to create multiple domains on a single Informatica server?
What are the various types of transformation?
What all are steps in up gradation of Informatica server?
Explain your project of banking domian.
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 domain in terms of informatica?
Why sorter is an active transformation?
How to elaborate tracing level?
How to generate sequence numbers using expression transformation?
What is the use of transformation?
What are the static cache and dynamic cache in informatica?
Explain lookup transformation source types in informatica
What is the format of informatica objects in a repository?
Explain transaction control transformation in informatica
What is fact table? Explain the different kinds of facts.
