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

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

detail about sdlc

4 Answers  

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

How do you find the number of rows in a sequential file?

1 Answers  

---

What are the different layers in the information server architecture?

0 Answers  

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

How to reverse the string using unix?

0 Answers   CTS,

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  

---

what are the types of nodes

4 Answers   HCL, TCS,

---

count number of deptno in a emp table?

2 Answers   IBM,

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---