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
- 7009 Views
- I also Faced
- E-Mail Answers
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 |
Name the different lookup cache(s)?
Why do we need informatica?
What are the different options available for update strategy?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
What are the connected or unconnected transforamations?
where to select code page option?
What is an unconnected transformation?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
how to get max value record into one target and remaining records into another target?
What are the data movement modes in informatcia?
how we can load rejected record's at run time?(not through bad files)
How identifying bottlenecks in various components of informatica and resolving them?
Teradata 
