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
- 9892 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
Plz can any one say me how to get the informatica certification materials and dumps
What are ETL Tools?
What is dynamic cache?
What are the guidelines to be followed while using union transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is primary and backup node?
What are session parameters ? How do you set them?
Differences between version 7.x and 8.x.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is resilience time?
which one is better performance wise joiner or look up
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is status code in informatica?
How can you validate all mappings in the repository simultaneously?
