Answer Posted / subhash

PIVOT finction available from ORCLE 11g Onwards:

SELECT *
FROM (SELECT customer_id, customer_quantity
FROM pivot_test)
PIVOT (customer_quantity FOR (customer_quantity
) IN (101, 102, 103))
ORDER BY customer_id;


Output:
1 101 102 103

Name the third party tools that can be used in datastage?

1141

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1923

---

What are the functionalities of link collector?

1138

---

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

1270

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2116

---

State the difference between an operational datastage and a data warehouse?

1185

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2324

---

Explain the importance of surrogate key in data warehousing?

1234

---

how to implement scd2 in datastage 7.5 with lookup stage

5666

---

whom do you report?

1986

---

Demonstrate experience in maintaining quality process standards?

2642

---

How a routine is called in datastage job?

1165

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3853

---

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

2777

---

What are the job parameters?

1269

---