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,

---

how you will maintain version?

3 Answers   CTS, TCS,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

Can you use flat files in Mapplets.

0 Answers  

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

What is rank transform?

0 Answers  

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---