Answer Posted / subhash

SELECT
CUST_ID,
DECODE(CUST_ID,'101',CUST_QUTY) AS CUST_QUTY1,
DECODE(CUST_ID,'102',CUST_QUTY) AS CUST_QUTY2,
DECODE(CUST_ID,'103',CUST_QUTY) AS CUST_QUTY3
FROM TABLE_NAME
GROUP BY CUST_ID;

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

2141

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2098

---

What are the steps needed to create a simple basic datastage job?

1246

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1224

---

Demonstrate experience in maintaining quality process standards?

2565

---

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

2510

---

describe the Steps to confiure a Qlogic switch

2390

---

How to find value from a column in a dataset?

2214

---

How many areas for files does datastage have?

1162

---

options available in sequence job to run,validate?

1327

---

What are the different type of jobs in datastage?

1046

---

What are the various kinds of the hash file?

1154

---

Which algorithm you used for your hashfile?

1190

---

What is a merge?

1177

---

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

2471

---