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
Can we get 1st record through Informatica(without sequence number).
What is a connected transformation?
How can we remove the duplicates from flat file source?
Explain about Informatica server process that how it works relates to mapping variables?
What is the session task and command task?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to delete duplicate row using informatica?
What is a filter transformation and why it is an active one?
Define mapplet?
Differentiate between sessions and batches?
How many ways are there to create ports?
What is sorter transformation?
tell me 5 session failure in real time how can you solve that in your project?
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?
What's the layout of parameter file (what does a parameter file contain?)?