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
- 7149 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
Explain what are the different types of transformation available in informatica.
How to implement security measures using repository manager?
Is there any way to read the ms excel datas directly into informatica?
Explain lookup transformation in informatica
What are the different lookup cache(s)?
What are the types of caches in lookup?
How to generate or load values in to the target table based on a column value using informatica etl tool.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to create Target definition for flat files?
Explain the shared cache and re-cache?
What is lookup transformation?
Enlist the differences between database and data warehouse.
how to load rows into fact table in data warehouse
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the different options available for update strategy?
