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?



hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s..

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

Post New Answer

More Informatica Interview Questions

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,


How to call shell scripts from informatica?

0 Answers  


What is the reusable transformation?

0 Answers  


Explain the aggregator transformation?

0 Answers  


Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  






If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,


What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,


I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,


Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  


Explain the types of lookup transformation?

0 Answers  


What is the sequence generator transformation in informatica?

0 Answers  


Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,


Categories