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
- 7250 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
Under which circumstances, informatica server creates reject files?
Define update strategy?
What is workflow manager?
How can you validate all mappings in the repository simultaneously?
What is a dimensional model?
What is the surrogate key?
What are the informatica performance improvement tips
Describe the impact of several join conditions and join order in a joiner transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the new features of informatica 9.x in developer level?
Can informatica load heterogeneous targets from heterogeneous sources?
generate date / time dimension in informatica
How do you handle two sessions in Informatica
How can you differentiate between powercenter and power map?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
