Interested to Buy Any Domain ? << Click Here >> for more details...
eno ename
1 qaz
1 wsx
1 edc
2 zxc
2 asd
3 qwe
3 wer
3 tru
4 rgj
Output:
eno ename count
1 qaz,wsx,edc 3
2 zxc,asd 2
3 qwe,wer,tru 3
4 rgj 1
I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
- 4 Answers
- 8432 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ajajsp
select eno, ename, count(*) from Table_Name group by eno, ename
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How do y read Sequential file from job control?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the components of ascential data stage?
Distinguish between informatica & datastage. Which one would you choose and why?
Define orabulk and bcp stages?
What is the different type of jobs in datastage?
What is ibm datastage flow designer?
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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Enlist various types of routines in datastage.
Differentiate between datastage and datastage tx?
