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

How do you promote a non-reusable transformation to reusable transformation?

1138

---

What is a difference between complete, stop and abort?

1083

---

Repository user profiles

1762

---

Explain how many types of dimensions are available in informatica?

1098

---

What are different types of transformations available in informatica?

991

---

What is the scenario which compels informatica server to reject files?

1070

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

---

What does update strategy mean, and what are the different option of it?

1089

---

what is the size of your data warehousing?

2095

---

What is expression transformation?

1098

---

What does role playing dimension mean?

1044

---

Can anyone tell me the new features in Informatica 9 Version?

2125

---

How can we remove the duplicates from flat file source?

1038

---

Which files are created during the session rums by informatics server?

1178

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1135

---