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
- 9267 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / c
In the expression transformation use the following:
select cno,substr(cname,1,position('@' in cname)-1)as cname,sal from sample
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Where can we find the throughput option in informatica?
What is the difference between informatica 7.0 and 8.0?
How can we use batches?
server hot-ws270 is connect to Repository B. What does it mean?
Why do you use Mapping Parameter and mapping variable?
Is it possible to define a single node as a Gateway node as well as worker node?
What is mapplet in informatica?
Repository user profiles
how we can load rejected record's at run time?(not through bad files)
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What does refresh system mean, and what are its distinctive choice?
What are the static cache and dynamic cache in informatica?
What is the benefit of partitioning a session?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
