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

Can you define merge?

0 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

I have 100 records how can I load at a time from the single time

1 Answers  

---

How to read the length of word in unix?

0 Answers   CTS,

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---