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.

What are Dimensional table?

0 Answers   Informatica,

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

What are the modules in Power Center

0 Answers  

---

How to create Target definition for flat files?

0 Answers   Informatica,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---

What is the difference between OLTP and ODS?

4 Answers  

---

what is Active lock explain

0 Answers   Satyam,

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

When you move from devel to prod how will you retain a variable

1 Answers  

---