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 ..

Differences between connected and unconnected lookup?

1130

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1744

---

What are the types of caches in lookup?

978

---

Why do we need informatica?

928

---

What is the need for an etl tool?

1013

---

what is degenerated dimension?

3873

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7072

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1796

---

What are the new features of informatica 9.x developer?

903

---

Explain the aggregator transformation?

1096

---

How to differentiate between the active and passive transformations?

1079

---

How might one distinguish in the case of mapping is right or not without associating session?

1028

---

How to create the source and target database connections in server manager?

1036

---

How to do unit testing in informatica? How to load data in informatica ?

1051

---

Explain joiner transformation in informatica

1077

---