Answer / d anil babu

hi this is anil.


seqfile---->transformer----->dataset

in transformer take constrain and in that ename=vijay and give
value 1 abort after rows in consrain window

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

Differentiate between datastage and datastage tx?

0 Answers  

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,

---

Describe routines in datastage? Enlist various types of routines.

0 Answers  

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

---

count number of deptno in a emp table?

2 Answers   IBM,

---

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---