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
Describe stream connector?
Does datastage support slowly changing dimensions ?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How one source columns or rows to be loaded in to two different tables?
Can you explain link buffering?
Can we use target hash file as a lookup ?
What is the purpose of pivot stage and types of containers in datastage
How do you generate sequence number in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How do y read Sequential file from job control?
Give an idea of system variables.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How can one find bugs in job sequence?
What are the stages in datastage?
What is the use of datastage director?