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.
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
Explian the Process of deployment groups in informatica
How to configure mapping in informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a router transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
Informatica settings are available in which file?
How do you update the records with or without using update strategy?
What are the different types of olap? Give an example?
Define enterprise data warehousing?
How can one identify whether mapping is correct or not without connecting session?
How can repository reports be accessed without sql or other transformations?
Under which circumstances, informatica server creates reject files?
What are the differences between oltp and olap?
When do you use sql override in a lookup transformation?