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

Answer / rajesh badra

use wm_concat or listagg

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.

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/

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

What is A complex mapping?

3 Answers   TCS,

---

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

0 Answers  

---

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

---

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

---

What is xml source qualifier transformation in informatica?

0 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---