Answer / masudul

Just pass the rows through an expression transformation.
then add a new port and write down the expression code-

substr(column_name, 1, (instr(column_name,'@')-1)).

See the output.

Answer / ankit kansal

Hi,
You can achieve it easily in expression transformation by making an extra out port where you just need to specify

substr('ankit42',1,instr('ankit42','4')-1) logic.

but keep in mind that all of your source data must contains 42 as defined in your problem.

http://deepinopensource.blogspot.in/

Answer / nsatyabrat7

use expression transformation and create a output port and use replacechr function.

replacechr(1,name,'@gmail.com',null) and connect the output port to target.

In Which scenario did u used Incremental loading?

2 Answers  

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

What is rank transformation in informatica

0 Answers   Informatica,

---

What aer the out put files that the informatica server creates during the session running?

4 Answers  

---

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

5 Answers   Accenture,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---