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
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 |
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
What are the types of schemas we have in data warehouse and what are the difference between them?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
What are the disadvantages of Sequence Generator T/R?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
how to return multiple columes through through un-connect lookup?
How many joins in Informatica
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?