30 jobs are running in unix.i want to find out my job.how
to do this?Give me command?
Answers were Sorted based on User's Feedback
Answer / mahesh
If you dont know the PID, try below:
ps -ef|grep USER_ID|grep JOB_NAME
Is This Answer Correct ? | 2 Yes | 0 No |
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
Unix command to view the data in a dataset
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
How do u set a default value to a column if the column value is NULL?
where we use config file as parameter ?
What are stage variables, derivations and constants?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
Difference in the implementation of lookup and join stages,in joining two tables?
what is sparse lookup?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the prerequisites for join stage