I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
Answer Posted / sagar patil
We can gone through with the unix.
Command ..sed 's/','/'-'/g' filename
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
To import the flat file definition into the designer where should the flat file be placed?
How to partition the Session?
How do you promote a non-reusable transformation to reusable transformation?
What do you understand by term role-playing dimension?
What is the difference between STOP and ABORT options in Workflow Monitor?
How would you join a node to the already existing domain?
What are the main issues while working with flat files as source and as targets ?
Quickly characterize reusable change?
Define filter transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Define the various join types of joiner transformation?
What are the different versions of informatica?
What are the types of caches in lookup? Explain them.
can we override a native sql query within informatica? Where do we do it?