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

Have you have ever worked in unix environment and why it is useful in datastage?

1100

---

Distinguish between informatica & datastage. Which one would you choose and why?

969

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1220

---

Define orabulk and bcp stages?

1090

---

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

904

---

How do you start developing a datastage project?

1077

---

What are sequencers?

1077

---

What are the stages in datastage?

1053

---

What is a merge in datastage?

1223

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2343

---

What are the different options associated with dsjob command?

1398

---

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

2423

---

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

2032

---

What are data elements?

1133

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2777

---