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

How do you load only null records into target?

0 Answers  


what is the monster dimension plz give me one example

2 Answers   EDS,


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


What is confirmed dimension?

3 Answers  


What is a predefined event?

0 Answers  


Mention a few design and development best practices for informatica?

0 Answers  


difference between shortcut and reusable transformation?

2 Answers  


What is a rank transform?

0 Answers  


My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,


can we override a native sql query within informatica? How do we do it?

0 Answers  


Categories