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.

What is meant by query override?

1008

---

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

2077

---

How we can use union transformation?

992

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1606

---

What all join we can perform in LOOKUP transformation?

916

---

Differentiate between Load Manager and DTM?

2096

---

Differentiate between a repository server and a powerhouse?

1046

---

What is xml source qualifier transformation in informatica?

1177

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1980

---

What is main use of mapplet?

1073

---

What is sorter transformation?

979

---

What is meant by active and passive transformation?

1031

---

How to create or import flat file definition in to the warehouse designer?

1023

---

Define sessions in informatica etl?

972

---

What is a router transformation?

1050

---