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
- 6701 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
What is surrogate key?
Tell me about Propagate functions in informatica
What is main use of mapplet?
how to call lookup qualifer in unconnected look;up
server hot-ws270 is connect to Repository B. What does it mean?
can we create index and drop index in exsisting table while using infomatica
What is router transformation
What do you mean by filter transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
What the difference is between a database, a data warehouse and a data mart?
Teradata 
