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
Answer Posted / 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 |
Post New Answer View All Answers
How to elaborate tracing level?
What is enterprise data warehousing?
Differentiate between joiner and lookup transformation?
Explain your project of banking domian.
What are the databases that informatica can connect to windows?
What is target designer and target load order?
Where are the source flat files kept before running the session?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to extract sap data using informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What differs when we choose the sorted input for aggregator transformation?
What is a sorter transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
To import the flat file definition into the designer where should the flat file be placed?