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
What is orabulk stage?
What are the types of containers and how to create them?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How one source columns or rows to be loaded in to two different tables?
How to convert RGB Value to Hexadecimal values in datastage?
How do you schedule or monitoring the job?
Can you explain engine tier in information server?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are constraints and derivations?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How to manage date conversion in Datastage?
How many areas for files does datastage have?
On which interface you will be working as a developer?
Have you have ever worked in unix environment and why it is useful in datastage?
What is a merge?