Answer / chandu

in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.

Answer / subhash

SORT -u file_name.txt
or
SORT|UNIQ file_name.txt

Answer / todearhari

Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.

Command:
Sort |Uniq

How to Convert the columns into rows?

2 Answers  

---

Define project in datastage?

0 Answers  

---

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

How did you reconcile source with target?

3 Answers   HP,

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

Can you explain repository tables in datastage?

0 Answers  

---