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
- 9102 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
How to implement security measures using repository manager?
How can you validate all mappings in the repository simultaneously?
How do you load alternate records into different tables through mapping flow?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How do you load unique records into one target table and duplicate records into a different target table?
How do you take back up of repository?
Explain what transformation and how many are there in informatica?
tell me 5 session failure in real time how can you solve that in your project?
Do you find any difficulty while working with flat files as source and target?
What are the databases that informatica can connect to windows?
Explain the different lookup methods used in informatica?
where to store informatica rejected data?
What is rank transformation?
What are the static cache and dynamic cache in informatica?
