Answer Posted / 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/

Differences between version 7.x and 8.x.

1840

---

How to generate sequence numbers?

1029

---

What do you mean by blocking transformation?

970

---

Define mapplet?

961

---

Explain the different dimensions.

913

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1429

---

can anyone suggest best free Talend data integration training online

1622

---

Difference between Data and Index Caches?

1091

---

How to create the source and target database connections in server manager?

1034

---

Describe data concatenation?

1005

---

What is workflow monitor?

997

---

What do you mean by channel change?

965

---

What are the informatica performance improvement tips

1017

---

What do you understand by SOA of Informatica?

925

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1015

---