What is exact difference between Parallel Jobs and server Jobs..

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which r the connectors used in san?

1784


Differentiate between data file and descriptor file?

611


Can you implement SCD2 using join, transformer and funnel stage?

1073


What are the different layers in the information server architecture?

638


What are orabulk and bcp stages?

638






What is active and passive stage?

872


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1693


How many areas for files does datastage have?

634


What are the types of containers in datastage?

697


what is the difference between == and eq in UNIX shell scripting?

967


Difference between ‘validated ok’ and ‘compiled’ in data stage?

663


root tree will find which is server job and which is parallel job?

1443


Differentiate between datastage and datastage tx?

586


How do you register plug-ins?

593


Differentiate between Join, Merge and Lookup stage?

639