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
- 7118 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
generate date / time dimension in informatica
How many input parameters can exist in an unconnected lookup?
As union transformation gives UNION ALL output, how you will get the UNION output?
I have a flat file, want to reverse the contents of the flat file
Define Pmrep command?
What are active and passive transformations?
How to call shell scripts from informatica?
What is informatica worklet?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is informatica? Why do we need it?
How can you differentiate between powercenter and power map?
How big was your fact table
What are the tuning techniques you applied during your last project
What is the sql query overwrite in source qualifier in informatica
Scheduling properties,whats the default (sequential)
