Answer / kumar

use reg_extract

refer this link
https://etltechsolutions.wordpress.com/2016/06/01/using-reg_extract/

its has the logic u need to change a bit as you have char as month.

Answer / isha

to_char(to_date(Date, 'dd/mon/yyyy'), 'dd mon yyyy')

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

without table how to come first record only in oracle?

0 Answers  

---

---

what is difference between COM & DCOM?

1 Answers   Satyam,

---

where to store informatica rejected data?

0 Answers  

---

What are Business Components in Informatica?

1 Answers  

---

Separate from a database, an information bazaar, and an information stockroom?

0 Answers  

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

What is powercenter on grid?

0 Answers  

---