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

Describe routines in datastage? Enlist various types of routines.

0 Answers  

---

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

---

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

What are stage variables and constants?

0 Answers  

---

What is meta stage?

0 Answers  

---

How can we improve performance of data stage jobs?

0 Answers  

---

How can one find bugs in job sequence?

0 Answers  

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---