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
- 7524 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
How you prepared reports for OLAP?
What is the Rank index port in Rank transformation?
How many ways are there to do 'remove duplicate records in informatica'?
permutations of mapplet
What is rank index in rank transformation?
How can we remove the duplicates from flat file source?
How to handle decimal places while importing a flatfile into informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Is stop and abort are same in informatica?
What is target load order?
How do you load alternate records into different tables through mapping flow?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
tell me 5 session failure in real time how can you solve that in your project?
What is the need of etl tools?
my source is junk data how will u remove that junk data by using unix please any one replay me
