Interested to Buy Any Domain ? << Click Here >> for more details...
source
file name xyz
a,0,a,a,a
b,b,b,0,b
c,c,c,0,c
target should be like this
xyz
a
b
c
how to implement this?
- 4 Answers
- 7376 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
don't specify delimiter while importing file and use similar function in informticw as
SELECT substr(REGEXP_REPLACE('a,0,a,a,a','[^[:alpha:]]',''),1,1) FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is domain and gateway node?
How to implement security measures using repository manager?
How many transformations can be used in mapplets.
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.
Explain in detail scd type 2 through mapping.
what is the difference between informatica6.1 and infomatica7.1
lookup transformation with screenshots
How do you set a varible in incremental aggregation
what is index?how it can work in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is standalone command task?
What does cheating measurement mean?
How can a transformation be made reusable?
What are the different ways to implement parallel processing in informatica?
Explain the different lookup methods used in informatica?
