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
- 7977 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Can we create out put ports in source qualifier t/r?
What are the types of groups in Router transformation?
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
How to update or delete the rows in a target, which do not have key fields?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
How can yoU improve session performance in aggregator transformation?
Separate from an archive server and a powerhouse?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
What is the procedure for creating independent data marts from informatica 7.1?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Teradata 
