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
Which means the first record should come as last record and last record should come as first record and load into the target file?
Define joiner transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the difference between informatica 7.0 and 8.0?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can we update a record in the target table without using update strategy?
can you please explain me pre session and post session options?
Performance tuning in UNIX for informatica mappings?
Explain sessions?
Which files are created during the session rums by informatics server?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Write the advantages of partitioning a session?
What are the measure objects?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Whats there in global repository