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 / hanan
src->exp->agg->tgt
src:-
In sql query write order by col1
exp:-
col1->
col2->
var_col2=iif(col1=var_col1,var_col2||','||col2)
var_col1=col1
output_port=var_col2
agg;-
select group by col1
tgt:-
connect to target
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
Differences between connected and unconnected lookup?
Explain what transformation and how many are there in informatica?
How an expression transformation differs from aggregator transformation?
What do you mean by channel change?
In informatics server which files are created during the session rums?
How to improve the performance of a session using sorter transformation?
Mention few power centre client applications with their basic purpose?
What is rank transform?
explain about unit testing? in real time?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to load last n records of file into target table - informatica
what are the deliverables?in your project?
What is enterprise data warehousing?
Partition, what happens if the specified key range is shorter and longer