how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

---

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

What is RCP

5 Answers   CGI, CTS,

---

How did you reconcile source with target?

2 Answers   HP,

---

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

---