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
- 9889 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
Have you worked with/created Parameter file
What is an active transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What do you understand by a term domain?
What is sq transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What do you mean by filter transformation?
what is informatica metadata?
How do you change a non-reusable transformation to reusable transformation?
What are the components of the workflow manager?
What are active and passive transformations?
How to partition the Session?
Explain pushdown optimization and types in informatica
