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
- 7145 Views
- KPIT, I also Faced
- E-Mail Answers
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
Explain the different lookup methods used in informatica?
What is rank transform?
waht type of interface is used for testing the data in informatica
How do you load first and last records into target table?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is an Integration service in Informatica?
which one is better performance wise joiner or look up
Why do you use Mapping Parameter and mapping variable?
What is flashback table ? Advance thanks
Explain in detail about scd type 1 through mapping.
When do you use sql override in a lookup transformation?
What is aggregator transformation in informatica?
can u give example for factless fact table
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the different lookup cache(s)?
