Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 8918 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sehaj
DO ONE THING....
CREATE AN EXTRA PORT FOR THAT.
IN THE EXPRESSION EDITOR,WRITE
REPLACESTR(0,cname,(SUBSTR(cname,INSTR(cname,'@'),INSTR(cname,'m',-1,1)),'')
PASS THIS PORT TO THE OUTPUT PORT......
SEHAJ-7204719446
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is deployment group?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is meant by LDAP users?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is rank transform?
What is sorter transformation?
How to generate sequence numbers using expression transformation?
How to handle decimal places while importing a flatfile into informatica?
can you please explain me pre session and post session options?
What is dimensional table? Explain the different dimensions.
What do you understand by a term domain?
What do you mean by worklet?
What is the difference between source qualifier transformations source filter to filter transformation?
