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.
Answers were Sorted based on User's Feedback
Answer / rajesh kumar
see while we load into source analyser as considerd as cama
separated it shows us 5 columns
now we should replace the 'cama' with null
use s->s/q-->expre-->target
give additional outputport as ename
exp condition=column2||''||column3||''||column3
Is This Answer Correct ? | 6 Yes | 1 No |
Go to the session properties.In that go to connections in that select the source name there you will find "Set file Properties" button. There you can set the delimeter.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rakesh
no my question is clear. and my target is oracle table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / 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 |
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
What is the maplet?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is the command used to run a batch?
What are the join types in joiner transformation?
How to do Integration testing in Informatica?
What are the uses of a Parameter file?
what are cost based and rule based approaches and what is the difference?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
In session log thier should not be a single error how will u do
How Union Transformation is an Active Trans?