What are the main diff between server job and parallel job in datastage

Showing Answers 1 - 16 of 16 Answers

sunilsavalasang

  • Oct 27th, 2006
 

in server jobs we have few stages and its mainly logical intensive and we r using transformer for most of the things and it does not uses MPP systems

in paralell jobs we have lots of stages and its stage intensive and for particular thing we have in built stages in parallel jobs and it uses MPP systems

  Was this answer useful?  Yes

In server we dont have an option to process the data in multiple nodes as in parallel. In parallel we have an advatage to process the data in pipelines and by partitioning, whereas we dont have any such concept in server jobs.

There are lot of differences in using same stages in server and parallel. For example, in parallel, a sequencial file or any other file can have either an input link or an output ink, but in server it can have both(that too more than 1).

  Was this answer useful?  Yes

N.sukumar

  • Dec 26th, 2006
 

server jobs can compile and run with in datastage server but parallel jobs can compile and run with in datastage unix server.

server jobs can extact total rows from source to anthor stage then only that stage will be activate and passing the rows into target level or dwh.it is time taking.

but in parallel jobs it is two types

1.pipe line parallelisam

2.partion parallelisam

1.based on statistical performence we can extract some rows from source to anthor stage at the same time the stage will be activate and passing the rows into target level or dwh.it will maintain only one node with in source and target.

2.partion parallelisam will maintain more than one node with in source and target.

  Was this answer useful?  Yes

ramesh

  • Oct 29th, 2007
 

The Main Diffrence is In Server job There are limited Stages So Mostly the Transformer is used but In Parallel lot of stages is there so the using of Tranformer is less This is because of Performance issue

  Was this answer useful?  Yes

Here in server we have to use some stages like link partitioner, link coll, inter process.. to implement ll'lism. And sometimes we have to use lot of stages to implement specific logic bcoz of few stages.. 

whereas in ll'll we have lot of stages, we can directly use those stages to impliment diff logics and performence will be more.

 ll' lal supports SMP AND MPP. and so on...


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions