What is exact difference between Parallel Jobs and server Jobs..
Answers were Sorted based on User's Feedback
Answer / kiran
Sorry Guys Your Answer is Wrong.
Server jobs don't support partitions and no parllalism and
its run only SMP mechines,.Performance is low
Parallal jobs Support Partions and parallism and its run on
SMP,MPP or Cluster Mechine(If require run on Us/OSS
Mechines also).Performance is high
| Is This Answer Correct ? | 18 Yes | 3 No |
Answer / madhava
Parallel jobs:
1.parallel jobs run on parallel engine.
2.Supports pipeline and partition parallelism.
3.compiled into OSH
server jobs:
1.run on server engine
2.doesn't support parallelism and partitioning techniques.
3.compiled in to BASIC language
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / yarramasu
server jobs have only one single node
parallel jobs have multiple nodes
server jobs can support only smp and doesnt support mpp
parallel jobs support smp and mpp
server jobs doesnt support pipeline partition
parallel jobs can support pipelilne parition
server jobs performence very low
parallel jobs performence very high
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / radha
i accept with kirans answer.
server job having only one node.there is no partitions
and parllel job contains mor than one node.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / venugopal
Server jobs can be run on SMP,MPP. performance is low
Parallel jobs can run on SMP,MPP or cluster systems.
performance is high
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / guest
parallel jobs run on cluster machines.
server jobs run on smp and mpp
| Is This Answer Correct ? | 2 Yes | 8 No |
Answer / prakash
Server jobs can be run on SMP,MPP machines.Here performance
is low i.e speed is less
Parallel jobs can be run only on cluster machines .Here
performance is high i.e speed is high
| Is This Answer Correct ? | 3 Yes | 11 No |
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
How complex jobs are implemented in datstage to improve performance?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
How to enter a log in auditing table whenever a job get finished?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
What are the repository tables in datastage?
What are routines in datastage? Enlist various types of routines.
What is datastage engine?
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?
What are stage variables?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks