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
- 22092 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 |
What is difference between symmetric multiprocessing and massive parallel processing?
in oracle target stage when we use load option and when we use upsert option?
What are stage variables, derivations and constants?
difference between server shared container and parallel shared container
What a datastage macro?
What is the difference between hashfile and sequential file?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
What is the difference between informatica and datastage?
Lookup constraints
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
How do you get log info into a file?
Teradata 
