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
How the ipc stage work?
Differentiate between validated and Compiled in the Datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the precedence of stage variables,derivations, and constraints?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you reject records in a transformer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Which algorithm you used for your hashfile?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the different options associated with dsjob command?
What is the use of hoursfromtime() function in transformer stage in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What could be a data source system?