Answer Posted / 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).

how to delete one row in target dataset

3122

---

Difference between in process and inter process?

1240

---

How a routine is called in datastage job?

1112

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

---

What is the difference between hashfile and sequential file?

1261

---

How do you schedule or monitoring the job?

1210

---

What is the difference between the local container and shared container?

1104

---

What are some prerequisites for datastage?

1100

---

What is aggtorec restructure operator?

1453

---

How rejected rows are managed in datastage?

1523

---

What are the types of hashed files in data stage

1108

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

---

What is job control?

1115

---

What can we do with datastage director?

1238

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

---