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
- 22063 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
Define Merge?
How you can fix the truncated data error in datastage?
What is use Array size in datastage
which r the connectors used in san?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is the difference between operational data stage (ods) and data warehouse?
What is the difference between in process and inter process?
Why we use surrogate key?
What is the project in datastage?
How do you reject records in a transformer?
Notification Activity
in oracle target stage when we use load option and when we use upsert option?
What a datastage macro?
What is apt_config in datastage?
What is the different type of jobs in datastage?
