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?

Answers were Sorted based on User's Feedback



Can anyone tell me, when a flat file contains different kinds of delimeters available for each line..

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

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line..

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

Post New Answer

More Informatica Interview Questions

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,






How is Data Models Used in Practice?

1 Answers  


What are events in workflow manager?

1 Answers   Accenture, IBM,


Explain the informatica workflow?

0 Answers  


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


Which are the different editions of informatica powercenter that are available?

0 Answers  


What is rank transformation?

0 Answers  


How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  


Categories