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;

sed,awk,head

1504

---

Is the value of staging variable stored temporarily or permanently?

1061

---

What are the different plug-ins stages used in your projects?

1128

---

What is the roundrobin collector?

1152

---

Explain datastage architecture?

1451

---

Which warehouse using in your datawarehouse

2242

---

Can you implement SCD2 using join, transformer and funnel stage?

1606

---

whom do you report?

1986

---

What is the difference between hashfile and sequential file?

1322

---

What are system variables and sequencers in datastage

1188

---

CHANGE CAPTURE

1356

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2079

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2215

---

how to add a new records into source?

2058

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2105

---