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
- 7235 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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What do you mean by channel change?
How many transformations can be used in mapplets.
Explain the shared cache and re-cache?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is domain and gateway node?
What is informatica?
What will be the approach?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Write the unconnected lookup syntax and how to return more than one column.
What is aggregator transformation in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
can anyone suggest best free Talend data integration training online
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is informatica? Why do we need it?
