Answer / pooja

Sort Stage
__________________________________________________________

1. Complex Sorts
2. When explicit Sorting Stage is required.
3. When Key change or cluster Key change columns are
required. As based on it the data needs to be filtered out
ahead in the job.

Sort performed in the input of few stages or Insort Stage
__________________________________________________________

1. Simple Sort
2. When there is no need to define a Sort stage explicitly.
3. There's no such option as key change here.


need to use
stage explicitly.

why dataset ?

2 Answers  

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

How do you remove duplicate values in datastage?

0 Answers  

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

Give an idea of system variables.

0 Answers  

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---

how to convert rows into columns

2 Answers   IBM,

---

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

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 is the use of surogate key in datastage

3 Answers  

---