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.

How many types of hash files are there?

0 Answers  

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---

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

0 Answers  

---

Define Data Stage?

0 Answers  

---

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

how does work server jobs?

1 Answers  

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

How do you generate sequence number in datastage?

0 Answers  

---