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
hi real timers . iam waiting for ur reply regarding ETL TESTING
Is it possible to use a client with different version than that of its Informatica server?
What is an Integration service in Informatica?
Performance tuning in UNIX for informatica mappings?
What are the features of complex mapping?
How to generate sequence numbers without using the sequence generator transformation?
What do you mean by enterprise data warehousing?
What is confirmed fact in dataware housing?
what is informatica metadata?
What does refresh system mean, and what are its distinctive choice?
Can we create a Integration service without a Repository service and vice versa?
How an expression transformation differs from aggregator transformation?
What are the databases that informatica can connect to windows?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
permutations of mapplet