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

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

What is factless fact schema?

1 Answers  

---

generate date / time dimension in informatica

0 Answers   Informatica,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

---

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?

0 Answers  

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

What do think which one is the better joiner or look up?

0 Answers  

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

---