Answer Posted / datastage4you

there are diff ways to call..

if Seq job :
Use command stage to call a shell script

or if job
go to the job properties and select "Before/After job
routine" and use ExecSH options to invoke shell script.


Thanks
http://datastage4you.blogspot.in/

how many rows sorted in sort stage by default in server jobs

3997

---

Enlist various types of routines in datastage.

1255

---

What could be a data source system?

1008

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1550

---

Differentiate between datastage and datastage tx?

1050

---

How do u convert the columns to rows in datastage?

1194

---

What is the command line function to import and export the ds jobs?

1151

---

whom do you report?

1929

---

Why fact table is in normal form?

1246

---

What is datastage engine?

1179

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2022

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

---

What can we do with datastage director?

1235

---

How to Remove Duplicate using SQL?

1363

---

What is process model?

1974

---