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
How do you take back up of repository?
How do you manage the Parameter files while migrating your data from one environment to another environment?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Define update strategy?
Make a note of the quantity vaults made in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What differs when we choose the sorted input for aggregator transformation?
Design time, run time. If you don't create parameter what will happen
How big was your fact table
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Differentiate between source qualifier and filter transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the meaning of decode in informatica?
what is the size of your data warehousing?