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
Have you used Unstructured data?
Difference between server jobs & parallel jobs?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How many areas for files does datastage have?
Explain the situation where you have applied SCD in your project?
Define orabulk and bcp stages?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are system variables and sequencers in datastage
What is the method of removing duplicates, without the remove duplicate stage?
Can you explain tagbatch restructure operator?
Define oconv () and iconv () functions in datastage?
What a datastage macro?
What are the steps needed to create a simple basic datastage job?
What is the flow of loading data into fact & dimensional tables?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...