Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9647 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 |
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are teh different tasks that can be created in workflow manager?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Why is meant by direct and indirect loading options in sessions?
What is dimensional table?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What are Target Options on the Servers?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
what are factless facts? And in which scenario will you use such kinds of fact tables.
Teradata 
