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.

Enterprise data warehouse your projects phase by phase explain?

1444

---

Explain sql transformation in script mode examples in informatica

590

---

How we can use union transformation?

599

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1031

---

Scheduling properties,whats the default (sequential)

1452

---

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1546

---

How can we use batches?

594

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

568

---

Explain the aggregator transformation?

617

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1692

---

What is the Process to creating lookup transformation in informatica

574

---

Did u used latest transformations of 8.6.0? for what?

1469

---

Explain incremental aggregation in informatica

644

---

what are the Methods For Creating Reusable Transformations?

640

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5751

---