Interested to Buy Any Domain ? << Click Here >> for more details...
i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
- 3 Answers
- 5799 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
using SQL
SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(TRANSLATE('101 a 101 b 101 c','1234567890',' '),' ','') DATA FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of an aggregator cache file?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
tell me the rules and responsblites in our project(my project is development)
Is it possible to define a single node as a Gateway node as well as worker node?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Enlist some properties of sessions.
How might you approve all mappings in the archive all the while?
Which development components of informatica have the highest usage?
How to load a Dimension ? and how to load a fact table?
How you can differentiate between connected lookup and unconnected lookup?
How an expression transformation differs from aggregator transformation?
What are the informatica performance improvement tips
where to store informatica rejected data?
How are indexes created after completing the load process?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
