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 the difference between lookup and sparse lookup?

1 Answers  

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

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,

---

What could be a data source system?

0 Answers  

---

what is .dsx files

3 Answers   IBM,

---

Differentiate between hash file and sequential file?

0 Answers  

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

---

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

---

Define project in datastage?

0 Answers  

---

How to remove blank spaces from data?

3 Answers  

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

---