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
- 9061 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
As union transformation gives UNION ALL output, how you will get the UNION output?
Design a mapping to load a target table with the following values from the above source?
What is the Rank index port in Rank transformation?
lookup transformation with screenshots
what are the deliverables?in your project?
what is informatica metadata?
what is the size of your data warehousing?
What is deployment group?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How can we improve session performance in aggregator transformation?
What does cheating measurement mean?
wf dont have integration severances how you can run?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Write the prerequisite tasks to achieve the session partition?
How to partition the Session?
