I have the source like
col1 col2
a l
b p
a m
a n
b q
x y
How to get the target data like below
col1 col2
a l,m,n
b p,q
x y
Answer Posted / venky
src->sorter->exp->agg->tgt
sorter:-
select col1 key as sorter
exp:-
var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output_port=var1
agg;-
select group by col1
tgt:-
connect to target
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
tell me 5 session failure in real time how can you solve that in your project?
How we can create indexes after completing the load process?
What is informatica? Why do we need it?
What is the use of target designer?
What is a dimensional model?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Write the different tools in the workflow manager?
How many ways are there to do 'remove duplicate records in informatica'?
What is an aggregator transformation?
what is size of u r database?
can you please explain me pre session and post session options?
Different qualification between a related rotate toward the sky and isolates look upward?
differences between service based and product based?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs