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

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

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

Ankit Kansal

This is wrong Concept....
First Try You

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

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,


Which is the t/r that builts only single cache memory?

0 Answers  


Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,


Global and Local shortcuts. Advantages.

0 Answers  


Different circumstance which drives informatica server to expel records?

0 Answers  


what is the complex transformation you used in informatica

0 Answers   TCS,


empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  


yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,


When do you use sql override in a lookup transformation?

0 Answers  


Could any one to tell Fact table Partitioning?

2 Answers  


hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  


Categories