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
- 5833 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
Differentiate between Load Manager and DTM?
What is source qualifier transformation in informatica?
Performance tuning in UNIX for informatica mappings?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
can we override a native sql query within informatica? How do we do it?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to load last n records of file into target table - informatica
How to handle decimal places while importing a flatfile into informatica?
What is data caches/ index caches?
How are the sources and targets definitions imported in informatica designer?
What is meant by target load plan?
what is song in infrmatica...?
Differentiate between router and filter transformation?
What is the use of source qualifier?
