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
- 7255 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 deployment group?
Differentiate between Load Manager and DTM?
What are the reusable transformations?
What are Dimensional table?
Explain in detail about scd type 1 through mapping.
What is rank transformation?
What is the command used to run a batch?
Describe expression transformation?
Explain how to import oracle sequence into informatica?
What are the differences between source qualifier and joiner transformation?
Explain the use of aggregator cache file?
How would you copy the content of one repository to another repository?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Write the program through which the records can be updated?
How to generate sequence numbers?
