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?
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 is the advantage of informatica?
What are the databases that informatica can connect to windows?
what are the deliverables?in your project?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is song in infrmatica...?
As union transformation gives UNION ALL output, how you will get the UNION output?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
In informatics server which files are created during the session rums?
tell me about your project functionality
What are multi-group transformations?
What are the types of caches in lookup?
What are the data movement modes in informatica?
What are active transformations.
What is the difference between STOP and ABORT options in Workflow Monitor?