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
Answers were Sorted based on User's Feedback
Answer / babu
Hi,
Below is the mapping for this scenario.
SEQ
||
SRC==>SQ==>EXP==>AGGR==>UNION==>FLT==>TGT
|| ||
EXP==============
1.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>
2.1.AGGR::ID
CNO=COUNT(ID)
2.2.EXP::SNO
ID
O_NAME
SAL
3.UNION the two pipelines(AGGR & EXP 2.2)
SNO
ID
O_NAME
SAL
CNO
4.FLLTER (SNO=CNO/2)
5.TGT
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is a test load?
what is the difference between Informatica7.1 & informatica 8.1
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Repository user profiles
what are challenges that you faced in testing? give solution to it?
Does Facttable Normalized or Denormalized?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
what is constraint based load order
What is the difference between procedure and stored procedur?
without update strategy how to insert &update?
How can i send first half of the records to one target and Remaining to other target?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.