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
- 6868 Views
- KPIT, I also Faced
- E-Mail Answers
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 are Rapid changing dimensions?
What are the options in the target session of update strategy transsformatioin?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
Parameter and variable differences
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Explain grouped cross tab?
how do u use sequence created in oracle in informatica? Explain with an simple example
which quality process u can approach in ur project
what are the settiings that u use to cofigure the joiner transformation?
What is the difference between a table and the materialized view?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
wt is Dynamic lookup Transformation? when we use?how we use?
Teradata 
