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
- 7527 Views
- DELL, I also Faced
- E-Mail Answers
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 meant by a domain?
Explain in detail scd type 2 through mapping.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the different lookup cache(s)?
How we can create indexes after completing the load process?
What is the benefit of session partitioning?
Repository user profiles
scenario where i can use only concurrent execution of workflow.
What are the advantages of informatica?
What are the informatica performance improvement tips
What are the static cache and dynamic cache in informatica?
What is joiner change?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How many transformations can be used in mapplets.
