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
- 9264 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
select substr(cname,1,instr(cname,'@')-1) from table name
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
What is informatica?
What is the fact table?
Whats the difference between informatica powercenter server, repositoryserver and repository?
in reporting we add some new objects,how we get the count of the newly added objects to the report
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is diff b/t sorter t/r and agg have the option sorter property...
what is mean by complex business rule ?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How would you copy the content of one repository to another repository?
How an expression transformation differs from aggregator transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is informatica? Why do we need it?
How can we handle two sessions in informatica?
What are the components of the workflow manager?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
