Interested to Buy Any Domain ? << Click Here >> for more details...
my source is like this id,name sal 10 abc 1000,10 pqr 2000,
10 xyz 3000 ,10 jkl 4000 and my requirement is like this
10 abc,pqr,xyz,jkl 2000 ....
i have try for this by using expression transformatin its ok
of the concatenation of second column but the thing is that
on third column if u group by using agg t/r the last value
will com i.e 4000 but i asked by a interviewer that i dont
want the first or last column i want the middle column i.e
2000 .plz reply for the same
- 2 Answers
- 6869 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / babu
Sorry to all,
Above answer is have small correction theat is very
difficult to explain here.
i will give one more solution, it is very simple
Mapping:
=======
SEQ
||
SRC=>SQ=>EXP=>AGGR(NOGROUPBY)=>TG1(ID,NAME)
||
EXP=======================FLT==TG2(SAL)
SQ::SELECT A.ID,A.NAME,A.SAL,(SELECT COUNT(ID) FROM TABLE
T) CNO FROM TABLE T
EXP::SNO(NEXTVALPORT) From Sequence generator
ID <input>
NAME <input>
O_NAME=(IIF(ID=V_ID,V_NAME||' ,'||NAME,NAME)) <Oport>
V_ID=ID <Variablr Port>
V_NAME=NAME <Variable Port>
SAL <I&O>
CNO
FLT:: SNO=CNO/2 RETURN SAL
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can anyone tell me the new features in Informatica 9 Version?
How can a transformation be made reusable?
What does reusable transformation mean?
How to partition the Session?
What are the different versions of informatica?
How can you increase the performance in joiner transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is standalone command task?
Why filter transformation is an active one?
What could be the possible resons of locks by user?
How do you migrate data from one environment to another?
How union transformation is used?
