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?
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
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|
what are the row and column separations in Flat Files
TELL ME ABOUT WORK FLOW SCHEDULING?
Which kind of index is preferred in DWH?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is sq transformation?
How u use pdf file in informatica source?
What is lookup transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Limitation of REPLACESTR. Is there any character limitation to it.
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
Enlist some properties of sessions.
when we go for unconnected lookup transformation? and why?