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
- 6915 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 create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to elaborate powercenter integration service?
Reusable transformation and shortcut differences
What is main use of mapplet?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the difference between informatics 7x and 8x and what is latest version?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
I have a flat file, want to reverse the contents of the flat file
What can we do to improve the performance of informatica aggregator transformation?
which one is better performance wise joiner or look up
Can you use flat files in Mapplets.
What are mapplets? How is it different from a Reusable Transformation?
EXL informatica Questions
Explain in detail about scd type 1 through mapping.
waht type of interface is used for testing the data in informatica
