my source contain data like this
cno cname sal
100 rama@gmail.com 1000
200 karuna@yahoo.com 2000
i want load my data to the target is
cno cname sal
100 rama 1000
200 karuna 2000
plz send the answer
Answer Posted / abhinaw prakash
1.Pass the coulmns to an expression transformation.
2.Create a variable port and use INSTR function to find the
location of @.
(INSTR(CNAME,'@')-1)
3.Create an output port and use SUBSTR function to extract
the substring from the string.
SUBSTR(CNAME,1,v_CNAME)
4.Pass it to the output port
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can one identify whether mapping is correct or not without connecting session?
What is different between the data warehouse and data mart?
I have a flat file, want to reverse the contents of the flat file
What are the different types of olap? Give an example?
How to load the data from people soft hrm to people soft erm using informatica?
What is repository manager?
What are the new features of informatica 9.x in developer level?
What are the different ways to implement parallel processing in informatica?
What are the differences between source qualifier and joiner transformation?
What is a sorter transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the different versions of informatica?
Why update strategy and union transformations are active?
How to load a Dimension ? and how to load a fact table?
What are the static cache and dynamic cache in informatica?