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
- 7089 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 are the steps involved in the migration from older version to newer version of Informatica Server?
How might one distinguish in the case of mapping is right or not without associating session?
explain one complex mapping with logic? sales project?
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 are the different types of olap? Give an example?
Mention few advantages of router transformation over filter transformation.
What are data-driven sessions?
Separate from a database, an information bazaar, and an information stockroom?
What is target designer and target load order?
How to generate sequence numbers without using the sequence generator transformation?
How do you take back up of repository?
What are the differences between joiner transformation and source qualifier transformation?
What is the maplet?
In warehouses how many schemas are there?
How an expression transformation differs from aggregator transformation?
