Answer / maruthi

1.)use to_integer('column name','newcolumn)
it works

what is galaxy repository?

2 Answers  

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

What are the modules in Power Center

0 Answers  

---

What is powercenter on grid?

0 Answers  

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

connected and unconnected lookups?

4 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---