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
- 7165 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
What are the different transaction levels available in transaction control transformation?
Explain the types of lookup transformation?
How an expression transformation differs from aggregator transformation?
How to load data in informatica ?
Define mapplet?
What are the main features of Oracle 8i with context to datawarehouse?
How can you generate reports in informatica?
what is INFORMATICA TESTING process
Do you find any difficulty while working with flat files as source and target?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is rank transformation in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Write the program through which the records can be updated?
What is a connected transformation?
What is the session task and command task?
