what is the unix script to run the job?
Please mention commands which we use often?
Answers were Sorted based on User's Feedback
Answer / shweta
Unix command to run Datastage job ::
dsjob -run -jobstatus projectname jobname
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sekhar naskar
/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -
wait -jobstatus -param
<Parameter_Name1>=<Parameter_Value1> -param
<Parameter_Name2>=<Parameter_Value2> <Project_Name>
<Job_Name>
Some times you can use dsjob instead
of /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / kiran
by using
dsjob -run -parametere<param name> -mode -wait -projectname
or -jobname
here ds job is command
-run is keyword
| Is This Answer Correct ? | 8 Yes | 4 No |
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How do you reject records in a transformer?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
Define Routines and their types?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
how to validate the jobs
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
what is the use of invokation id
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to find no.of records in sequntial file itself?
How to Remove Duplicate using SQL?