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.
Answer Posted / guest
Your question seems need some correction.
Source might be as below
eno, ename, sal
111, sri ram kumar, 1000
and target you might need like a space delimited one. If
this is the case you can sed command to replace the string.
if your file is as mentioned by you also it will be same.
If my understanding is wrond then eleborate your question
clearly.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is repository manager?
What is event and what are the tasks related to it?
When do you use sql override in a lookup transformation?
What is workflow manager?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the procedure for creating independent data marts from informatica 7.1?
What is decode in static cache?
What is the need of an ETL tool?
What are mapplets?
What are the informatica performance improvement tips
Explain sessions?
Why sorter is an active transformation?
Explain in detail about scd type 1 through mapping.
Define sessions in informatica etl?
What is sq transformation?