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
- 7679 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
What is the use of transformation?
what is the size of your data warehousing?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to differentiate between the active and passive transformations?
What is the sequence generator transformation in informatica?
According to his methodology what all you need before you build a datawarehouse
What is mapplet in informatica?
How can you differentiate between powercenter and power map?
What is event and what are the tasks related to it?
What is union transformation in informatica?
What is an unconnected transformation?
In informatics server which files are created during the session rums?
can anyone explain me about retail domain project in informatica?
What is the use of target designer?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
