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

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

1205

---

What is difference between server jobs & parallel jobs?

986

---

What are the functionalities of link partitioner and link collector?

950

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3607

---

AGGREGATOR default datatype

1387

---

Difference between data warehousing and olap?

1042

---

How a source file is populated?

1018

---

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

1833

---

What is the difference between datastage and datastage tx?

1008

---

Is it possible to query a hash file?

1951

---

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

2043

---

Notification Activity

1348

---

what is use of SDR function?

5127

---

Have you used Unstructured data?

1267

---

What are sequencers?

1057

---