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

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---