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
- 7940 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ahalya inturi
Go to the session properties.In that go to connections in that select the source name there you will find "Set file Properties" button. There you can set the delimeter.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
What is mapping debugger?
which one is better performance wise joiner or look up
Can you generate sequence numbers without using the sequence generator transformation?
What are the databases that informatica can connect to windows?
Sequence generator, when you move from develoment to production how will you reset
What is the advantage of informatica?
What is workflow manager?
How can we improve session performance in aggregator transformation?
What is a rank transform?
In which transformation you cannot drag ports into it?
Explain why we use partitioning the session in informatica?
What are the main issues while working with flat files as source and as targets ?
how to load rows into fact table in data warehouse
What is the difference between router and filter?
