Interested to Buy Any Domain ? << Click Here >> for more details...
cust id,cust quty like 1,101;1,102;1,103 i want output like
cust id,cust quty 1 101,102,103 in oracle please write a
query in oracle
- 3 Answers
- 8156 Views
- TCS, I also Faced
- E-Mail Answers
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;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can you explain tagbatch restructure operator?
What is ds designer?
Can you explain kafka connector?
Explain how a source file is populated?
What are the different types of lookups in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
why do u need the IOS upgradation in a FC switch
If you want to use the same piece of code in different jobs, how will you achieve it?
How many areas for files does datastage have?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is active and passive stage?
What are stage variables, derivations and constants?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Why do we use link partitioner and link collector in datastage?
Difference between data warehousing and olap?
