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

Have you used Unstructured data?

839


Difference between server jobs & parallel jobs?

657


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1724


How many areas for files does datastage have?

644


Explain the situation where you have applied SCD in your project?

1568






Define orabulk and bcp stages?

690


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.

2434


What are system variables and sequencers in datastage

615


What is the method of removing duplicates, without the remove duplicate stage?

592


Can you explain tagbatch restructure operator?

705


Define oconv () and iconv () functions in datastage?

886


What a datastage macro?

640


What are the steps needed to create a simple basic datastage job?

667


What is the flow of loading data into fact & dimensional tables?

600


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...

3762