count number of deptno in a emp table?
- 2 Answers
- 4479 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naganji mandru
Using aggrgator one way,Another way write query from database stage like
Select deptno,count(*) as c from emp group by deptno
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nish
use aggregator stage: Group by Deptno.
In the calculation field: select RecCount
this will create a new column with count of deptno. Make sure to map to the output stage.
Hope this helps your poorly framed question.
| Is This Answer Correct ? | 1 Yes | 0 No |
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Difference between server jobs & parallel jobs?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
HOW CAN WE SEE THE DATA IN DATASET?
Differentiate between hash file and sequential file?
how do u capture duplicates through sort & transformer
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
In merge stage can we update the values?
Teradata 
