Answer Posted / archana
When we have lots of functionality to implement for lower volume and hardware is less and ease of implementation we can go for Server jobs.
We can improve the performance of server job by enabling inter process row buffering. This helps stages to exchange data as soon as it is available in the link. IPC stage also helps passive stage to read data from another as soon as data is available.
The choice of server or parallel depends upon time to implement, functionality and cost.
Server jobs do not run on multiple node.
server job runs on windows platform usually
server job runs on one node
Server jobs process in sequence one stage after other
Server jobs doesn't support partition parallelism
server jobs the transformer is compiled in Basic language.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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...
What are routines in datastage?
what is the difference between == and eq in UNIX shell scripting?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Lookup constraints
Difference between in process and inter process?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the functionalities of link partitioner?
Can we use target hash file as a lookup ?
Why do we use link partitioner and link collector in datastage?
What are some different alternative commands associated with "dsjob"?
What are the primary usages of datastage tool?
What are the different kinds of views available in a datastage director?
How to read the length of word in unix?
What are transforms and what is the differenece between routines and transforms?
