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 |
Define repository tables in datastage?
How many jobs in ur project? Explain any complex job u have done in ur project?
What is the roundrobin collector?
How do you reject records in a transformer?
what is .dsx files
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
Differentiate between data file and descriptor file?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
what is use of SDR function?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
Differentiate between hash file and sequential file?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?