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
- 7966 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
If informatica has its scheduler why using third party scheduler?
Explain what are the different versions of informatica?
What are mapplets? How is it different from a Reusable Transformation?
Write the advantages of partitioning a session?
What does cheating measurement mean?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Under what condition selecting sorted input in aggregator may fail the session?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What will be the approach?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Write the prerequisite tasks to achieve the session partition?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
When do you use sql override in a lookup transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
