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 |
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
how to capture rejected data by using join stage not for lookup stage. please let me know
Is there any possibility to generate alphanumeric surrogate key?
How to delete the data in dataset?types of deleting the data in dataset?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
Give example for FACTLESS FACT TABLE in real-time scenario.
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
how can find maximum salary by using Remove duplicate stage?
What is the default execution order of the sequential file?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
How can u write exception handling in seq file????
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2