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
- 7674 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 |
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What is the default join that source qualifier provides?
What are the different lookup cache(s)?
How to eliminate duplicate records in informatica mapping? Explain with an example....
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is source qualifier transformation in informatica?
can u any challenge your project?
What are the performance considerations when working with aggregator transformation?
waht type of interface is used for testing the data in informatica
What is the Difference between DSS & OLTP?
without table how to come first record only in oracle?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
Teradata 
