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
- 7055 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 the Process to creating lookup transformation in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
list out all the transformations which use cache?
Explain the mapping variable usage example in informatica
What is an expression transformation?
Why is sorter an active transformation?
where to store informatica rejected data?
What are roles and groups and benefits of using them?
explain about unit testing? in real time?
explain one complex mapping with logic? sales project?
what is INFORMATICA TESTING process
What are the uses of etl tools?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain your project of banking domian.
Parameter and variable differences
