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
- 22234 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
Describe link sort?
What is datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Nls stands for what in datastage?
What is the use of datastage designer?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Can you explain tagbatch restructure operator?
What are the some differences between 7.x and 8.x version of datastage?
What is the difference between datastage and informatica?
What is staging variable?
Define repository tables in datastage?
What is a merge?
How a routine is called in datastage job?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
