Interested to Buy Any Domain ? << Click Here >> for more details...
my source is a comma delimited flatfile as
eno, ename, sal
111,sri,ram,kumar,1000
and my target should be
eno ename sal
111 sri ram kumar 1000
i.e; we need to eliminate the commas in between the data of a comma delimited file.
- 5 Answers
- 9638 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
Go to session --> Mapping tab --> click on your target file --> Select File Properties (from the file properties in the right)
This will open the file properties window, click on the advanced button and in the next popup you should be able to see the delimiter option in the top. You can now replace the delimiter you want with the existing one.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make Data masking in informatica..
Whats there in global repository
what are 3 tech challenges/ common issues you face?
What can we do to improve the performance of informatica aggregator transformation?
What are connected or unconnected transformations?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
wat are deployement groups in informatica, how it will be used for developers
Under what condition selecting sorted input in aggregator may fail the session?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the types of data warehouses?
What is lookup transformation?
difference between informatica 8.1.1 and 8.6
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is standalone command task?
Can we override a native sql query within informatica?
