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
- 7942 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
What is incremental aggregation?
Which are the different editions of informatica powercenter that are available?
what is the difference between informatica6.1 and infomatica7.1
What is a node in Informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to extract sap data using informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Target increases every day even though no new record was inserted
Enlist the differences between database and data warehouse.
Differentiate between joiner and lookup transformation?
What is exclusive and normal mode for repository services?
What is informatica? Why do we need it?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Which transformation is needed while using the Cobol sources as source definitions?
