Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove ctrl M or(^M) characters in file using Sequential File stage?
- 2 Answers
- 22109 Views
- Bank Of America, Satyam, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
1) In Sequential file, we have an option like 'filter'.
in the filter we can mention like:
sed 's/\^M//g' FileName.txt
or
2) we can do this in Before job routine(executeSH) and we can cal this in Seq file stage. here we can use UNIX command 'unix2dos fileName.txt'
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What can we do with datastage director?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Explain connectivity between datastage with datasources?
What is the difference between informatica and datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are transforms and what is the differenece between routines and transforms?
Can you implement SCD2 using join, transformer and funnel stage?
Can we use target hash file as a lookup ?
What are the types of containers?
What steps should be taken to improve Datastage jobs?
What are the some differences between 7.x and 8.x version of datastage?
How can one find bugs in job sequence?
What are the different kinds of views available in a datastage director?
What are the functionalities of link partitioner?
Triggers,VIEW,Procedures
