Answer Posted / raj

There are two requirements here
1. Counting
2. Converting rows to columns

Here is the design of the job
Source -> Pivot(Vertical) -> Transformer -> Destination

Pivot:
1. Use vertical pivot.
2. Mention Company as Group by column and Location as pivot. In the aggregate column choose count

Transformer:
1. Above pivoting gives locations in different columns. Use transformer to concatenate these columns using : operator

what are the devoleper roles in real time? plz tell i am new to datastage....

2212

---

project Steps,hits, Project level HArd things,Solved methods?

2182

---

How one source columns or rows to be loaded in to two different tables?

1174

---

How do you import and export data into datastage?

1294

---

Name the command line functions to import and export the DS jobs?

1199

---

Define data aggregation?

1147

---

Which commands are used to import and export the datastage jobs?

1460

---

Differentiate between datastage and datastage tx?

1111

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2776

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1544

---

What are the different layers in the information server architecture?

1173

---

Have you have ever worked in unix environment and why it is useful in datastage?

1181

---

What are the types of hashed files in data stage

1146

---

What are the components of ascential data stage?

1240

---

What is the purpose of pivot stage and types of containers in datastage

1082

---