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
- 7771 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 |
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How does the aggregator transformation handle null values?
What are the different lookup cache(s)?
what is the difference between informatica6.1 and infomatica7.1
what is session override?
How mapping parameter and variable works
How do you join more than 3 flat files in informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
Sequence generator, when you move from develoment to production how will you reset
Which transformation should u need while using the cobol sources as source defintions?
Teradata 
