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
- 9270 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 the use of an aggregator cache file?
define galaxy repository in informatica
Enlist the tasks for which source qualifier transformation is used.
Mention few power centre client applications with their basic purpose?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is sequence generator transformation in informatica?
What is joiner change?
What are the components of Informatica? And what is the purpose of each?
While migrating the data from one environment to another environment how would you manage the connections?
what is the Default Source Option For Update Strategy Transformation?
How do you set a varible in incremental aggregation
How does a sorter cache works?
What are the different transaction levels available in transaction control transformation?
What will be the approach?
What is the need of an ETL tool?
