Answer / kiran

Yes you can, as long as your client is OK with it. We
design jobs to finish certain tasks in ETL. If your task
has less data and more complex tranformations then use
server jobs and vice versa.

Answer / nish

Yes,

For jobs that are less resource intensive create a server job.

Create the parallel job as usual

Create a sequencer to combine both jobs or configure a shared container in one of the jobs and re -use them

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---

What is datastage?

0 Answers  

---

Describe the main features of datastage?

0 Answers  

---

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

---

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,

---

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

which r the connectors used in san?

0 Answers  

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

---

what is ds administrator used for?

0 Answers  

---