SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle &

SOURCE
1 a
1 b
1 c
2 a
2 b
2 c

TARGET
1 A B C
2 A B C

In oracle & informatica level how to achieve

Question Posted / gangadhar799

4 Answers
6542 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica lev..

Answer / mr.lee

Is This Answer Correct ?

1 Yes

0 No

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica lev..

Answer / rajesh badra

use wm_concat or listagg

Is This Answer Correct ?

1 Yes

0 No

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica lev..

Answer / parikhita prusty

first sort the first column empid using sorter t/r then
expersion t/r create variable port
v_ename:=iff(prev.empid=curr.empid,v_ename||' '||ename,ename)
o_ename=v_ename
then using expersion t/r convert lower case higher case. any
doubt mail me.

Is This Answer Correct ?

1 Yes

1 No

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica lev..

Answer / ankit kansal

Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||' '||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT

Using Oracle

select value from (
select id ||' '||upper(name) ||' '|| lead(upper(name),1) over (partition by id order by id) ||' '|| lead(upper(name),2) over (partition by id order by id) value from ankit_temp order by 1
)temp where length(value)>0 order by value;

http://deepinopensource.blogspot.com/

Is This Answer Correct ?

1 Yes

2 No

Post New Answer