What is exact difference between Parallel Jobs and server Jobs..
Answers were Sorted based on User's Feedback
Answer / sathya seenu priya.a
SERVER JOBS PARALLEL JOB
RUN ON SINGLE NODE MULTIPLE NODE
PIPELINING &
PARTITIONING DOES NOT SUPPORT SUPPORTS
LOADS WHEN 1 JOB FINISH SYNCHRONIZED
SERVER JOBS USES
SYMMETRICMULTIPROCESSING
PARALLEL JOBS
BOTH MASSIVE PARALLEL PROCESSING AND
SYMMETRICMULTIPROCESSING
| Is This Answer Correct ? | 41 Yes | 2 No |
Answer / bharath
SERVER JOBS
->Runs on single node
->Executes on DS Server Engine
->Handles less volume of data
->Slow data processing
->Having less no. of components(i.e, palette)
->Compiled into Basic language.
PARALLEL JOBS
->Runs on multiple nodes.
->Executes on DS parallel engine.
->Handles Huge volume of data
->Faster data processing.
->Having more no. of components
->Compiled into OSH(orchestrate shell script) except transformer( C++ and OSH )
| Is This Answer Correct ? | 26 Yes | 1 No |
Answer / poonam
Parallel jobs are carriedout on miltiple nodes/processors
but in server jobs no multitasking is there to talk in
simple terms. There are many technical differences like no
server sort stage etc but this is the basic difference
| Is This Answer Correct ? | 19 Yes | 9 No |
Answer / manash roy chawdhury
Parallel jobs are carriedout on miltiple nodes/processors
but in server jobs no multitasking is there to talk in
simple terms.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / geed
Parallel job run on multithreading where as server job run
on singlethread.
parallel job we can use millions of data to run by using
nodes and partition where server job we can use small amount
of data so that the output will be retrived faster,since it
single threading.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / karan khera
PARALLEL SERVER
Multinode Single node
Many processes can run ||lly Single process at a time
Much more stages Very less stages
Easy functionality Hard functionality
Datasets are there Datasets are not present
APT_CONFIG_FILE present No APT_CONFIG_FILE
More environment variable Meagre Environment vrbls
Join,lookup is there No join,lkup by x-frmr
Run faster due to multinode for large data run slow
Partition is there No partition
OSH compiled code BASIC compiled code
Database System File system
Works on Unix system Works on Windows system
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shali
In parallel we can have multiprocessing (multinodes), But
in server its not there.
Server working with pipeline concept,parallel working in
the principle of parallelism
| Is This Answer Correct ? | 4 Yes | 8 No |
Answer / chenna
Parallel Jobs haveing a huge amount of data to maintains.
server Jobs haveing a low amount of data to maintains.
Parallel Jobs it having a more stages comperies server
Jobs .
Parallel Jobs or supports smp,mpp.
server Jobs does not support smp,mpp.
| Is This Answer Correct ? | 5 Yes | 9 No |
What are the prerequisites for join stage
whats relation between configuration file and datasets?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
How to Convert the columns into rows?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
difference between server shared container and parallel shared container
Describe link sort?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 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 in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .