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

How many types of sorting methods are available in datastage?

1075

---

What are the primary usages of datastage tool?

1075

---

What is the sortmerge collector?

1132

---

How can we improve performance of data stage jobs?

1018

---

How to RD using transformer?

1429

---

What is the flow of loading data into fact & dimensional tables?

1065

---

How do you register plug-ins?

966

---

What is the difference between in process and inter process?

1155

---

How can one find bugs in job sequence?

1419

---

What is oci?

1304

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044

---

What all the types of jobs you developed?

1181

---

What are the steps required to kill the job in Datastage?

1218

---

Demonstrate experience in maintaining quality process standards?

2556

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088

---