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 / krishna
select substr(cname,1,instr(cname,'@')-1) from table name
Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
What is a surrogate key?
How would you copy the content of one repository to another repository?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Mention some types of transformation?
What does reusable transformation mean?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How can we store previous session logs?
What is the use of target designer?
What is a passive transformation?
Explain how many types of dimensions are available in informatica?
How can a transformation be made reusable?
What is union transformation?
Enlist the differences between database and data warehouse.
What is informatica worklet?
Explain what are the different types of transformation available in informatica.