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
- 2 Answers
- 6650 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Explain the different kinds of facts.
What are the designer tools for creating tranformations?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
what is mystery dimension?
what is the difference between copy object import objects using repositery manager which one is best
How can u work with remote database in informatica?did you work directly by using remote connections?
explain different types of modeling.
What is the difference between stop and abort in informatica
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
How you know when to use a static cache and dynamic cache in lookup transformation?
Teradata 
