Hi Gus,
Can u pls tell me
How can u Call the Shell Scripting/Unix Commands in Job
Sequence?
Answers were Sorted based on User's Feedback
Answer / kiran
hai vijay..,
by using Routines activity.u can access unix/shellscript
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 This Answer Correct ? | 5 Yes | 0 No |
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
how to sort two columns in single job in datastage.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Where do the datastage jobs get stored?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to abort the job its matain duplicates?
What's the Main Function of the Staging area in DWH
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
What are the important features of datastage?
Explain the situation where you have applied SCD in your project?
Explain the datastage parallel extender (px) or enterprise edition (ee)?