Answer / naga

connect sequential file to dataset and use partition
technique and perform sort and select unique

Answer / vinod upputuri

In the sequential File stage there is a option called filter.
there we can use UNIX command.

syntax for Remove duplicate: uniq or sort -u

Answer / subhash

small correction to Vinod answer,
If we use UNIQ, it will remove duplicate if they are
consecutive only..
so, better to use
sort -u
or
sort file_name | uniq

Answer / topper

Select the data set and press delete..

What is merge stage?

0 Answers  

---

How many types of hash files are there?

0 Answers  

---

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  

---

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

---

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

what is .dsx files

3 Answers   IBM,

---

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

---

What are the types of hashed files in data stage

0 Answers  

---