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
- 9728 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
permutations of mapplet
What is sq transformation?
What is Index Caches size?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Target increases every day even though no new record was inserted
I have a flat file, want to reverse the contents of the flat file
What is rank transform?
wf dont have integration severances how you can run?
What is a filter transformation and why it is an active one?
Explain pushdown optimization and types in informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
how many types of dimensions are available in informatica?
Under which circumstances, informatica server creates reject files?
How can informatica be used for an organization?
What are the different components of powercenter?
