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
7994 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

More Informatica Interview Questions

What is expression transformation?

0 Answers

What is the difference between warehouse key and surrogate key?

1 Answers Accenture,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers TCS,

What is a filter transformation?

0 Answers

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers Informatica,

What are the mapings that we use for slowly changing dimension table?

2 Answers

What is batch and describe about types of batches?

2 Answers

What is the difference b/w natural key and surrogate key

1 Answers

What are the limitations of joiner transformation?

0 Answers Informatica,

What are the reusable transforamtions?

2 Answers

i have two source data there is no pk,fk how to join the two sources

5 Answers TetraSoft,

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers

For more Informatica Interview Questions Click Here