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
- 9468 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to extract sap data using informatica?
How to start a workflow using pmcmd command?
What is event and what are the tasks related to it?
What are the popular informatica products?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a node in Informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain how to import oracle sequence into informatica?
What is union transformation in informatica?
How do you update the records with or without using update strategy?
Enlist the various types of transformations.
How to create or import flat file definition in to the warehouse designer?
What is repository manager?
What is joiner transformation?
