What is exact difference between Parallel Jobs and server Jobs..
- 7 Answers
- 17449 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 |
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
Describe stream connector?
what is a message handler
What are the primary usages of datastage tool?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
What are the difference types of stages?
What all the types of jobs you developed?
What is the sortmerge collector?
What is merge stage?
how do you pass parameters in a script?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
when we will use connected Lookup & Unconnected Lookup
Teradata 
