i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
- 3 Answers
- 5254 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 are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you change a non-reusable transformation to reusable transformation?
tell me about your project functionality
what are the Methods For Creating Reusable Transformations?
Explain about Informatica server process that how it works relates to mapping variables?
Explain sessions?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the types of transformations?
What is update strategy transform?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the new features of informatica 9.x developer?
What is a surrogate key?
Enlist some properties of sessions.
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is informatica?
