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
- 9720 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 a joiner transformation and why it is an active one?
What are the measure objects?
What is rank transform?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the various types of transformation?
Explain the different kinds of facts.
Write the advantages of partitioning a session?
can we override a native sql query within informatica? Where do we do it?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is joiner change?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the differences between oltp and olap?
How to do unit testing in informatica? How to load data in informatica ?
What are the main issues while working with flat files as source and as targets ?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
