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
- 9648 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 do you load first and last records into target table?
Explain the etl program with few examples.
What are ETL Tools?
What is a pre-defined event and user-defined event?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
can you please explain me pre session and post session options?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is informatica? Why do we need it?
On which transformations you created partitions in your project?
explain about unit testing? in real time?
Can you generate sequence numbers without using the sequence generator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What are the features of complex mapping?
Where do we use mapping variables in informatica?
