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
- 7675 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 decode in informatica?
Different sorts of metadata that stores in the storage facility?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain dynamic target flat file name generation in informatica
Where are the source flat files kept before running the session?
How do you convert single row from source into three rows into target?
How to delete duplicate row using informatica?
What is the function of aggregator transformation?
What are the differences between joiner transformation and source qualifier transformation?
Can we create multiple integration service on single repository?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Difference between Data and Index Caches?
What the difference is between a database, a data warehouse and a data mart?
During the running session, output files are created by informatica server. Enlist few of them.
