Answer / maruthi

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

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

How can we use batches?

0 Answers  

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Do you find any difficulty while working with flat files as source and target?

0 Answers  

---

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

---