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
- 5975 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
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain in detail about scd type 1 through mapping.
Why sorter is an active transformation?
What is union transformation?
explain about unit testing? in real time?
Briefly describe lookup transformation?
What are the tasks that can be performed using sq?
Explain the scenario which compels informatica server to reject files?
Differences between version 7.x and 8.x.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a sorter transformation?
waht type of interface is used for testing the data in informatica
Plz can any one say me how to get the informatica certification materials and dumps
Enlist the advantages of informatica.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
