Interested to Buy Any Domain ? << Click Here >> for more details...
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
- 3 Answers
- 7631 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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/
| Is This Answer Correct ? | 1 Yes | 3 No |
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.
| Is This Answer Correct ? | 1 Yes | 4 No |
What is meant by query override?
How can we get multiple output values using an unconnected lookup transformation?
During the running session, output files are created by informatica server. Enlist few of them.
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
when informatica 8 series released ?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
I have a flat file, want to reverse the contents of the flat file
how we can do session partition in informatica any one explain me clearly? thanks advance.
what type of transformation is not supported by mapplets?
Label in Informatica. How to remove existing Label.
tell me about your project functionality
How to use Normalizer transformation?
Teradata 
