Answer Posted / dilip ingole

in sql use
SELECT REGEXP_REPLACE('9975344018', '(d{3})(d{3})(d{4})', '(1)-2-3') FROM DUAL;


in informatica also same use REG_REPLACE instead of REGEXP_REPLACE ..

How we can use union transformation?

1104

---

Quickly characterize reusable change?

1184

---

What are ETL Tools?

1171

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2151

---

Explain the difference between mapping parameter and mapping variable?

1083

---

What is joiner transformation in informatica?

1100

---

write a query to retrieve the latest records from the table sorted by version(scd)

1114

---

Define pmcmd command?

1105

---

can u give example for factless fact table

6780

---

Define sessions in informatica etl?

1101

---

What is an active transformation?

1159

---

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

1131

---

What is rank index in rank transformation?

1129

---

How to go to the older version for a mapping?

1157

---

What is primary and backup node?

1174

---