GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 262 of 374    Print  
what are the main diff between server job and parallel job in datastage

  
Total Answers and Comments: 6 Last Update: January 25, 2008     Asked by: prasanna 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 27, 2006 00:35:40   #1  
sunilsavalasang        

RE: what are the main diff between server job and par...

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


 
Is this answer useful? Yes | No
December 06, 2006 05:57:00   #2  
amardeep.reddy Member Since: December 2006   Contribution: 5    

RE: what are the main diff between server job and par...

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


 
Is this answer useful? Yes | No
December 26, 2006 08:48:49   #3  
N.sukumar        

RE: what are the main diff between server job and par...

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.


 
Is this answer useful? Yes | No
October 29, 2007 07:07:49   #4  
ramesh        

RE: what are the main diff between server job and par...
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
 
Is this answer useful? Yes | No
January 18, 2008 04:22:01   #5  
sanchit_states Member Since: January 2008   Contribution: 1    

RE: what are the main diff between server job and parallel job in datastage
server jobs while using look up converts code into .osh language
while Parallel converts the code in C++ code ..leading to the req of VC++ compiler.

 
Is this answer useful? Yes | No
January 25, 2008 04:58:27   #6  
manoharkolukula Member Since: January 2008   Contribution: 29    

RE: what are the main diff between server job and parallel job in datastage
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...



 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape