Answer Posted / shar

Well the Question is not clear at the moment.
if ur question is
1)single col with single row like
name
ram,rakesh,madhan,suraj,pradeep,bhaskar
then
ur requirement of asking is again this?
like
ram,rakesh,madhan,suraj,pradeep,bhaskar
or
2)single col with multiple rows like
ram
rakesh
madhan
suraj
pradeep
bhaskar
and u want o/p like ram,rakesh,madhan,suraj,pradeep,bhaskar.
Then praney anwer doesn't suite to get output.
neither u can use pivot stage using vertical pivoting bec
what will u pivot and group by.... not possible.
Finally one way is:

Use SeqStg-->ColGen-->Tx-->RemDup-->Dataset.
At colgen give a new column and assign 1 to all rows and
send the result to tx.
At tx take three variables and expressions to concatenate
the input with the help of colgen new column.
Hint: If sv1 <> sv3 Then DSLink45.cname Else sv2 : ',' :
At RemDup specify Last value
And finally u will the output.

Still if u dont get what i explained just mail me
shharrath@yahoo.com

What is ds designer?

1078

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1244

---

What is difference between join, merge and lookup stage?

1078

---

Demonstrate experience in maintaining quality process standards?

2522

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2040

---

EXPLAIN SCD

1380

---

How do y read Sequential file from job control?

15919

---

describe the Steps to confiure a Qlogic switch

2364

---

How can you write parallel routines in datastage PX?

997

---

What are the partitioning techniques available in link partitioner?

2258

---

What is the purpose of interprocessor stage in server jobs?

2218

---

How complex jobs are implemented in datstage to improve performance?

1019

---

What are the features of datastage flow designer?

1020

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1047

---

Highlight the main features of datastage?

1144

---