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 to create user defined function (udf) in informatica

1350

---

How can we create index after completion of load process?

1165

---

What is the fact table?

1136

---

Write the prerequisite tasks to achieve the session partition?

1227

---

explain abt ur project architecture?

2233

---

Explain sessions?

1140

---

What is the commit type if you have a transaction control transformation in the mapping?

1099

---

What is union transformation in informatica?

1192

---

Mention some types of transformation?

1096

---

How are the sources and targets definitions imported in informatica designer?

1170

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2370

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2301

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10321

---

How we can create indexes after completing the loan process?

1251

---