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

864

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2207

---

Can you implement SCD2 using join, transformer and funnel stage?

1495

---

Demonstrate experience in maintaining quality process standards?

2454

---

Can you explain tagbatch restructure operator?

1114

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2155

---

What is the difference between odbc and drs stage?

1042

---

Lookup constraints

1199

---

Nls stands for what in datastage?

1141

---

How do you run datastage job from the command line?

1026

---

What is a datastage job?

962

---

Is it possible to query a hash file?

1950

---

Is possible to create skid in dim,fact tables?

2586

---

What is ibm datastage?

914

---

Where do the datastage jobs get stored?

1149

---