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

Name the different lookup cache(s)?

1 Answers  

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---

How can repository reports be accessed without sql or other transformations?

1 Answers  

---

what is the hint? how to use it to reduce the query processing in program?

4 Answers   Cegedim,

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

Differentiate between router and filter transformation?

1 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

How to display null values on a target & non-null values on a target?

3 Answers  

---

Define mapping and session?

1 Answers   Informatica,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1 Answers  

---

What do you mean by worklet?

1 Answers  

---