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')

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

What is olap (on-line analytical processing?

0 Answers  

---

---

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

How many repositories can we create in Informatica?

3 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

Why do we need informatica?

0 Answers  

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---