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
- 7074 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
permutations of mapplet
Explain sessions and how many types of sessions are there?
How do you update the records with or without using update strategy?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
lookup transformation with screenshots
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the use of code page?
What is persistent lookup cache?
How to do unit testing in informatica?
What are the types of presistent cache in look up tr.
What is mapplet in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the different dimensions.
Please let me know how to make Data masking in informatica..
