Answer Posted / 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.

What are routines in datastage?

1265

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1069

---

What is a folder? Difference types of stages?

1102

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2406

---

What is a merge?

1076

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1444

---

What is the difference between validated and compiled in the datastage?

1190

---

Can you highlight the main features of ibm infosphere information server?

1045

---

what is the use of surogate key in datastage

2249

---

What is the difference between server job and parallel jobs?

1092

---

Define meta stage?

1143

---

What is use Array size in datastage

1719

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2837

---

How we can covert server job to a parallel job?

1061

---

What is the difference between informatica and datastage?

1146

---