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

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.

How to reverse the string using SQL?

0 Answers   CTS,

---

what is a nodemap constraint

2 Answers   IBM,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

what is data mapping

2 Answers  

---