Interested to Buy Any Domain ? << Click Here >> for more details...
What is exact difference between Parallel Jobs and server Jobs..
- 7 Answers
- 20173 Views
- IBM, I also Faced
- E-Mail Answers
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 |
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
How to read multiple files using a single datastage job if files have the same metadata?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
why we use parameters instead of hard code in datastage
What is the difference between the local container and shared container?
1)How to Duplicate Records Delete in Sequential file?
What is RCP
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
i want job aborted after some records are loaded into output by using only sequential stage and dataset
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
Teradata 
