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
- 22201 Views
- Bank Of America, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / subhash (subbuchamala)
We can use these ways also to remove Control M Characters
tr -d '\r' < yourfile.txt > yourfile1.txt
mv yourfile1.txt yourfile.txt
or
Change the line terminator in Sequential File stage from
UNIX-style to DOS-style(it's a stage property).
| Is This Answer Correct ? | 3 Yes | 0 No |
How do you start developing a datastage project?
What is the difference between informatica and datastage?
what is snow flack schema?
Explain Quality stage?
How do you get log info into a file?
How can you find out whether datastage process is running or not in unix?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
What can we do with datastage director?
What is a datastage job?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How to move data set from one server to other?what are the steps to follow to do this?
Teradata 
