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.

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2262

---

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

---

Can you explain kafka connector?

1312

---

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

1169

---

What steps should be taken to improve Datastage jobs?

1074

---

Explain connectivity between datastage with datasources?

977

---

Have you have ever worked in unix environment and why it is useful in datastage?

1133

---

What is ibm datastage flow designer?

1150

---

Define orabulk and bcp stages?

1123

---

Which warehouse using in your datawarehouse

2186

---

What is aggtorec restructure operator?

1453

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1216

---

Define data aggregation?

1102

---

Which commands are used to import and export the datastage jobs?

1414

---

Difference between server jobs & parallel jobs?

1078

---