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 |
where the log files or tables can store in DS?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what are the different type of errors in datastage?
Can you explain repository tables in datastage?
What is size of a transaction and an array means in a datastage?
how to do pergformence tuning in datastage?
What are iconv and oconv?
What is apt_config in datastage?
Name the different types of Lookups in Datastage?
How many jobs in ur project? Explain any complex job u have done in ur project?