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
- 6634 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 types of schemas we have in data warehouse and what are the difference between them?
How we can create indexes after completing the load process?
Partition, what happens if the specified key range is shorter and longer
Can we change Dynamic to Static or Persistent cache? If so what happens?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the different types of olap? Give an example?
Which are the different editions of informatica powercenter that are available?
How many numbers of sessions can one group in batches?
What are the different versions of informatica?
What is the reusable transformation?
What is an Integration service in Informatica?
Explain the difference between a data warehouse and a data mart?
What will be the approach?
