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
- 7430 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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to open an older version of an object in the workspace?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain sql transformation in script mode examples in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is dimensional table?
What does update strategy mean, and what are the different option of it?
Is stop and abort are same in informatica?
Explain incremental aggregation in informatica
How to do unit testing in informatica? How to load data in informatica ?
What do you mean by enterprise data warehousing?
What is a passive transformation?
What are the modules in Power Center
How to extract sap data using informatica? What is abap? What are idocs?
What is a snowflake schema?
