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..

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

what is a message handler

3 Answers   IBM,

---

What are the types of containers?

0 Answers  

---

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

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  

---

how do u capture duplicates through sort & transformer

4 Answers  

---

What is the default padding character?

3 Answers   IBM,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 Answers  

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

How a server job can be converted to a parallel job?

0 Answers  

---