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;

What are orabulk and bcp stages?

1070

---

why do u need the IOS upgradation in a FC switch

2225

---

How to reverse the string using SQL?

1427

---

I have a few records just I want to store data in to targets cycling way how?

2304

---

How to read the length of word in unix?

1313

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

888

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1001

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2405

---

How do you import and export the datastage jobs?

1110

---

Describe the main features of datastage?

1039

---

What are the some differences between 7.x and 8.x version of datastage?

1207

---

what is use of SDR function?

5128

---

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

1163

---

What all are the different way to run a job?

1030

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3078

---