Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

Can we use target hash file as a lookup ?

0 Answers  

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

What is size of a transaction and an array means in a datastage?

0 Answers  

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---