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
- 7814 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 are the deliverables?in your project?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a filter transformation and why it is an active one?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What if the source is a flat-file?
What are the types of lookup transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a snowflake schema?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the procedure for creating independent data marts from informatica 7.1?
Under which circumstances, informatica server creates reject files?
What is rank transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Write the unconnected lookup syntax?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
