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
- 7249 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / zaheer
One more thing, its possible for a flat file when delimeters
are common or same for each and every record by mentioned in
flat file wizard. But just thing is there any other process
to do above first question
| Is This Answer Correct ? | 3 Yes | 2 No |
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Write the different tools in the workflow manager?
Is it possible to have "5 source & 5 Target" in single mapping?
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Can we create two repositories on same database instance in oracle?
Partition, what happens if the specified key range is shorter and longer
What are the new features of the server manager in the informatica 5.0?
How to recover the standalone session?
What is A complex mapping?
Is stop and abort are same in informatica?
difference between stop and abort
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
Teradata 
