I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

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,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

What is lookup change?

0 Answers  

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---