Answer / chethankumar km

using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

What is a ds designer?

0 Answers  

---

whom do you report?

0 Answers   NTT Data,

---

What is the process of killing a job in datastage?

0 Answers  

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

how can we create tables in datastage?

1 Answers  

---

What are the types of containers and how to create them?

0 Answers  

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers  

---