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
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 |
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 |
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 |
How do you load only null records into target?
what is the monster dimension plz give me one example
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
hi all, Can anyone please tell me the relationship between informatica and business objects
What is confirmed dimension?
What is a predefined event?
Mention a few design and development best practices for informatica?
difference between shortcut and reusable transformation?
What is a rank transform?
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.
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.
can we override a native sql query within informatica? How do we do it?