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
How can we improve session performance in aggregator transformation?
What is the maplet?
What are the reusable transformations?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
define galaxy repository in informatica
lookup transformation with screenshots
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is source qualifier transformation in informatica?
Informatica settings are available in which file?
What is Index Caches size?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain incremental aggregation in informatica
What do you mean by enterprise data warehousing?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?