Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

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

what are the row and column separations in Flat Files

3 Answers   CTS,


3 Answers   TCS,

Which kind of index is preferred in DWH?

2 Answers  

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

What is sq transformation?

0 Answers  

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

What is lookup transformation?

0 Answers  

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

Enlist some properties of sessions.

0 Answers  

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,