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'

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).

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

What are operators in datastage?

1 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

Where do the datastage jobs get stored?

0 Answers  

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

What are stage variables?

0 Answers  

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---