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.

How do you change a non-reusable transformation to reusable transformation?

0 Answers  

---

What is an Integration service in Informatica?

0 Answers  

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

How the dimensions will be loaded?

0 Answers   HCL,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

---

What is session task and command task?

0 Answers  

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---