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
- 9261 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / shweta123
In the expression transformation use the following
function :
substr(name,1,(length(name) - instr(name,@,-1,1)))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is complex mapping?
What if the source is a flat-file?
What is Cognos script editor?
What are the differences between source qualifier and joiner transformation?
What is the use of transformation?
Can we create two repositories on same database instance in oracle?
What is meant by a domain?
Explain incremental aggregation in informatica
What is a sequence generator transformation?
What is rank transformation in informatica
What are the uses of etl tools?
What are the various types of transformation?
How to join three sources using joiner?
What do you understand by term role-playing dimension?
What is sequence generator transformation in informatica?
