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
- 7955 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
Go to session --> Mapping tab --> click on your target file --> Select File Properties (from the file properties in the right)
This will open the file properties window, click on the advanced button and in the next popup you should be able to see the delimiter option in the top. You can now replace the delimiter you want with the existing one.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many types of sessions are there in informatica.please explain them?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the function of union transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Design time, run time. If you don't create parameter what will happen
What are the different types of repositories created using informatica?
What are the advantages of informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Which is the t/r that builts only single cache memory?
which one is better performance wise joiner or look up
How are indexes created after completing the load process?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Separate from an archive server and a powerhouse?
In development project what is the process to follow for an etl developer from day1
