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
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
Can we get 1st record through Informatica(without sequence number).
Please let me know how to make Data masking in informatica..
how to load dimension table and fact table. plz tell me the steps.
Plz can any one say me how to get the informatica certification materials and dumps
What do mean by local and global repository?
can we override a native sql query within informatica? How do we do it?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to differentiate between the active and passive transformations?
Separate from an archive server and a powerhouse?
What is the difference between Active and Passive transformation?
Target increases every day even though no new record was inserted
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How can we store previous session logs?