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

What is the need for an etl tool?

0 Answers  

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

---

What is IQD file?

1 Answers  

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

What is parallel processing in informatica?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

---