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
- 7802 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is index?how it can work in informatica
How you prepared reports for OLAP?
Explain in detail about scd type 1 through mapping.
What if the source is a flat-file?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Can we create two repositories on same database instance in oracle?
Explain the features of connected and unconnected lookup.
what are 3 tech challenges/ common issues you face?
What are the main features of Oracle 8i with context to datawarehouse?
What all join we can perform in LOOKUP transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How does a rank transform differ from aggregator transform functions max and min?
What is blocking transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
