how do u capture duplicates through sort & transformer

4 Answers  

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  

---

What is difference between join, merge and lookup stage?

0 Answers  

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---