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
- 9649 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
how many types of dimensions are available in informatica?
State the differences between sql override and lookup override?
Explain the scenario which compels informatica server to reject files?
Explain the pipeline partition with real time example?
How many transformations can be used in mapplets.
differences between service based and product based?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the cumulative sum and moving sum?
What is a transaction control transformation?
How we can create indexes after completing the loan process?
What are the settings that you use to configure the joiner transformation?
what is mean by complex business rule ?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
