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
- 9111 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
Write the unconnected lookup syntax?
How to update or delete the rows in a target, which do not have key fields?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a shortcut and copy in Informatica and how two are different with each other?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can anyone tell me the new features in Informatica 9 Version?
What are the restrictions of union transformation?
What is sq transformation?
What is a node in Informatica?
Explain joiner transformation in informatica
Enlist some properties of sessions.
What are the settings that you use to configure the joiner transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
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. ?
Informatica Checkpoints
