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
- 7630 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a predefined event?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is expression transformation?
what is the size of u r source(like file or table)?
Explain the difference between a data warehouse and a data mart?
what is the hint? how to use it to reduce the query processing in program?
What is lookup transformation?
What is the difference between informatica 7.0 and 8.0?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is a code page?
What is a router transformation?
What is blocking transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
