Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone tell me, when a flat file contains different
kinds of delimeters available for each line ( For Ex: First
line contains [,*&#$] and second line contains [%@$#%^].
Like that all records having different kinds of delimeters.
How can we implement this kind of flat file in informatica?
- 2 Answers
- 6999 Views
- I also Faced
- E-Mail Answers
Answer Posted / murali udayagiri
Write a pre-process shell script by using the below 2nd
command and overwrite to another file, use overwritten file
as source for loading.
1)
$ cat multi_delimeter.txt
1,murali%100#10
2%krishna#200,20
3%sasi%232,10
1%murali%100,30
4,krish,200%20
2)
$ sed -e 's/,/|/g' -e 's/%/|/g' -e 's/#/|/g' multi_delimeter.txt
1|murali|100|10
2|krishna|200|20
3|sasi|232|10
1|murali|100|30
4|krish|200|20
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the advantage of informatica?
What are the components of the workflow manager?
How to go to the older version for a mapping?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
where to store informatica rejected data? How to extract the informatica rejected data?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is a repository manager?
What is mapping debugger?
pmscmd startworkflow -sv
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Can you generate sequence numbers without using the sequence generator transformation?
In which transformation you cannot drag ports into it?
What is meant by a domain?
What is xml source qualifier transformation in informatica?
