Answer / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

difference between shortcut and reusable transformation?

2 Answers  

---

What are the modules in Power Center

0 Answers  

---

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

What is dimensional table?

0 Answers  

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

can we create index and drop index in exsisting table while using infomatica

4 Answers  

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---