Interested to Buy Any Domain ? << Click Here >> for more details...
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 .
- 2 Answers
- 5096 Views
- CTS, I also Faced
- E-Mail Answers
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
How to extract the informatica rejected data?
Why do we need informatica?
What are the mapping parameters and mapping variables?
How many numbers of sessions can one group in batches?
how to load dimension table and fact table. plz tell me the steps.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the reusable transformation?
How can we use batches?
How to update a particular record in target with out running whole workflow?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to Create a folder using pmrep command?
What are junk dimensions?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Whats the difference between informatica powercenter server, repositoryserver and repository?
