Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7289 Views
- DELL, I also Faced
- E-Mail Answers
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
What is a repository manager?
How do you handle two sessions in Informatica
What is lookup transformation?
What is rank transform?
what are the deliverables?in your project?
How to update or delete the rows in a target, which do not have key fields?
Explain your project of banking domian.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the differences between joiner transformation and source qualifier transformation?
What is event and what are the tasks related to it?
Explain the features of connected and unconnected lookup.
What is complex mapping?
How to call shell scripts from informatica?
Informatica Checkpoints
Explain joiner transformation in informatica
