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
- 6560 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
Briefly explain the aggregator transformation?
have u done any performance tuning? how u ll do?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the different types of repositories created using informatica?
How to load last n records of file into target table - informatica
Is it possible to use a client with different version than that of its Informatica server?
What are the types of lookup transformation?
Explain scd type 3 through mapping.
What is the need of etl tools?
Difference between Data and Index Caches?
How to use pmcmd utility command?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a node in Informatica?
How to configure mapping in informatica?
difference between informatica 8.1.1 and 8.6
