Answer / pushpendra

replacechr function can use.

replacechr(0,Column_Name,' ','')

Answer / xx

Its always better to use reg_replace check the below link

https://etltechsolutions.wordpress.com/category/informatica/

Answer / kartik

Hops I ound Trip Time robe1
to
Hops I ound Trip Time robe1

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

What is rank transformation?

0 Answers  

---

How are parameters defined in informatica?

3 Answers   HP, TCS,

---

---

can you use flat file for repository?why?

2 Answers   TCS,

---

What is informatica? Why do we need it?

0 Answers  

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

How will the document be delivered to me?

0 Answers  

---

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

---