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/

Explain how a source file is populated?

1415

---

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)

964

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3181

---

What is the project in datastage?

1159

---

What are stage variables, derivations and constants?

1280

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2137

---

How many Key we can define in remove duplicate stage?

1436

---

Can you explain players in datastage?

1245

---

Explain ibm infosphere information server and highlight its main features?

1135

---

What are the steps required to kill the job in Datastage?

1264

---

Why do you need stage variables?

1229

---

What is datastage?

1130

---

Differentiate between hash file and sequential file?

1120

---

Explain the situation where you have applied SCD in your project?

2085

---

What is size of a transaction and an array means in a datastage?

1366

---