Answer / j madhava rao

$sort -u filename will sorts the data and removes the duplicates lines from the output

Answer / vishwababu

You can use UNIQ to remove duplicates frm a file but it can
consider only same consecutive records.
Ex: if u hve records as
1 vishwa
1 Shruti
2 Ravi
3 Naveen
1 vishwa
and if u use UNIQ cmd, then you wil get vishwa, Ravi, Naveen
and vishwa.
So perform sort before using UNIQ so tat to avoid duplicates

Answer / prasad

Uniq -u File_name

It will remove duplicates records.

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

How to remove blank spaces from data?

3 Answers  

---

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

---

Differentiate between odbc and drs stage?

0 Answers  

---

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

---

How many input links can you give to a Transformer stage?

6 Answers  

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---

how many stages are there in Datastage... Please clarify mee??

3 Answers  

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

---

CHANGE CAPTURE

0 Answers   CTS,

---