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
- 9063 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 a difference between complete, stop and abort?
Is there any target staging area in informatica not staging area
Explain the different kinds of facts.
What is standalone command task?
Under what condition selecting sorted input in aggregator may fail the session?
Tell me about Propagate functions in informatica
Explain the different dimensions.
What are the advantages of using informatica as an etl tool over teradata?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a code page?
What is intricate mapping?
What is status code in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain incremental aggregation in informatica
Quickly characterize reusable change?
