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 .
Answers were Sorted based on User's Feedback
Answer / vamshi
here is the solution for your question
tested
https://etltechsolutions.wordpress.com/2016/05/23/replace-comma-with-tab-everywhere-except-enclosed-in-a-pair-of-double-quotes/
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sagar patil
We can gone through with the unix.
Command ..sed 's/','/'-'/g' filename
Is This Answer Correct ? | 0 Yes | 4 No |
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is dimensional table? Explain the different dimensions.
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
what r the transformations that r not involved in mapplet?
How to load duplicate records in to a target table which has a primary key?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
How to improve the performance of a session using sorter transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is a code page?
what we require for D.modelling?