Interested to Buy Any Domain ? << Click Here >> for more details...
count number of deptno in a emp table?
- 2 Answers
- 5426 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 |
how does work server jobs?
how to find diff between 2 dates without using Icon... funtions?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
What are the components of ascential data stage?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
What are the important features of datastage?
Explain usage analysis in datastage?
Name the command line functions to import and export the DS jobs?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Teradata 
