Answer / sathya seenu priya.a

SERVER JOBS PARALLEL JOB


RUN ON SINGLE NODE MULTIPLE NODE


PIPELINING &
PARTITIONING DOES NOT SUPPORT SUPPORTS

LOADS WHEN 1 JOB FINISH SYNCHRONIZED

SERVER JOBS USES
SYMMETRICMULTIPROCESSING

PARALLEL JOBS
BOTH MASSIVE PARALLEL PROCESSING AND
SYMMETRICMULTIPROCESSING

Answer / bharath

SERVER JOBS
->Runs on single node
->Executes on DS Server Engine
->Handles less volume of data
->Slow data processing
->Having less no. of components(i.e, palette)
->Compiled into Basic language.

PARALLEL JOBS
->Runs on multiple nodes.
->Executes on DS parallel engine.
->Handles Huge volume of data
->Faster data processing.
->Having more no. of components
->Compiled into OSH(orchestrate shell script) except transformer( C++ and OSH )

Answer / poonam

Parallel jobs are carriedout on miltiple nodes/processors
but in server jobs no multitasking is there to talk in
simple terms. There are many technical differences like no
server sort stage etc but this is the basic difference

Answer / manash roy chawdhury

Parallel jobs are carriedout on miltiple nodes/processors
but in server jobs no multitasking is there to talk in
simple terms.

Answer / geed

Parallel job run on multithreading where as server job run
on singlethread.
parallel job we can use millions of data to run by using
nodes and partition where server job we can use small amount
of data so that the output will be retrived faster,since it
single threading.

Answer / 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

Answer / shali

In parallel we can have multiprocessing (multinodes), But
in server its not there.

Server working with pipeline concept,parallel working in
the principle of parallelism

Answer / chenna

Parallel Jobs haveing a huge amount of data to maintains.
server Jobs haveing a low amount of data to maintains.
Parallel Jobs it having a more stages comperies server
Jobs .
Parallel Jobs or supports smp,mpp.
server Jobs does not support smp,mpp.

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

How many areas for files does datastage have?

0 Answers  

What is job control?

0 Answers  

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

What is the default padding character?

3 Answers   IBM,

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  

how can we create tables in datastage?

1 Answers