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
- 7815 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
What is an expression transformation in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is meant by target load plan?
What is the difference between STOP and ABORT options in Workflow Monitor?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to start a workflow using pmcmd command?
Mention a few design and development best practices for informatica?
Enlist the various types of transformations.
What is sequence generator transformation in informatica?
How to open an older version of an object in the workspace?
How do you update the records with or without using update strategy?
What do you mean by filter transformation?
Plz can any one say me how to get the informatica certification materials and dumps
How to update or delete the rows in a target, which do not have key fields?
