Answer / srinivas

Dataset is a file which can be used for stored data as intermediate result.
Compared to other files processing is fast by using the Dataset because its internal format is DataStage support format.
Most of the times we can use this as intermediate data storage.
One added advantage is node system we can use multiple nodes
in dataset.

We have lot of uses by using this file dataset.

In server edition we have hashfile same way in parllel edition we will use DataSet.

Answer / guru_avula

where we use column generator stage in real time scenario?

5 Answers   TCS,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

sed,awk,head

0 Answers   CTS,

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

---

How to add zero "0" before record in a field?

4 Answers  

---

how to export or import the jobs in .ISX file

0 Answers  

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,

---

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---