Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7580 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
What is informatica metadata and where is it stored?
Different sorts of metadata that stores in the storage facility?
What is the different lookup cache(s)?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the new features of informatica 9.x developer?
Describe expression transformation?
Differentiate between reusable transformation and mapplet.
what is diff b/t sorter t/r and agg have the option sorter property...
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to load data in informatica ?
What is informatica?
What is the function of union transformation?
How to configure mapping in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Separate from an archive server and a powerhouse?
