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
- 9461 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
What is enterprise data warehousing?
What is the use of target designer?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Repository user profiles
Define mapplet?
How to create or import flat file definition in to the warehouse designer?
What does cheating measurement mean?
Explain sessions and how many types of sessions are there?
What are the types of data warehouses?
Explain why we use partitioning the session in informatica?
How do you change a non-reusable transformation to reusable transformation?
Explain sessions. Explain how batches are used to combine executions?
How can you differentiate between powercenter and power map?
How does a rank transform differ from aggregator transform functions max and min?
What is informatica? Why do we need it?
