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
- 22200 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 are the job parameters?
Can you define merge?
What are stage variables?
Define Job control?
Lookup constraints
Can you explain players in datastage?
why do u need the IOS upgradation in a FC switch
Differentiate between Join, Merge and Lookup stage?
Differentiate between datastage and datastage tx?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is merge stage?
How many Key we can define in remove duplicate stage?
What is the difference between datastage and datastage tx?
in oracle target stage when we use load option and when we use upsert option?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
