Answer Posted / pavan

Hi,

There are two scenarios where u myt want to call a script

Scenario 1(Dependency exists between script and a job):
Where a job has to be executed first then the script has to
run, upon completion of script execution only the sec job
has to be invoked. In this case develop a sequencer job
where first job activity will invoke the first job then
using Execute command activity call the script u would
desire to invoke by typing "sh <script name>" in the
command property of the activity, then with the other job
activity call the second job.

Scenario 2: (Script and job are independent) : In this case
right in your parallel job say job1, under job properties u
can find "After-job subroutine" where u need to
select "ExecSH" and pass the script name which you would
like to execute. By doing this once the job1 execution
completes the script gets invoked. The job succeeding the
job1 say job2 doesnt wait for the execution of the script.

What are some different alternative commands associated with "dsjob"?

1106

---

Differentiate between datastage and informatica?

1151

---

how to export or import the jobs in .ISX file

1142

---

what are the errors,warnings in datastage

2634

---

What are the partitioning techniques available in link partitioner?

2237

---

What is active and passive stage?

1372

---

What are the steps needed to create a simple basic datastage job?

1178

---

On which Dimension Table you implemented SCD Type in your Project

1976

---

What are stage variables, derivations and constants?

1173

---

Describe link sort?

970

---

Difference between sequential file and data set?

1149

---

Why fact table is in normal form?

1161

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1002

---

What are the benefits of datastage?

1193

---

What is ibm datastage?

924

---