Interested to Buy Any Domain ? << Click Here >> for more details...
count number of deptno in a emp table?
- 2 Answers
- 5391 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 |
Describe link sort?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
How to enter a log in auditing table whenever a job get finished?
Can you highlight the main features of ibm infosphere information server?
what is parameterset?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What are the difference types of stages?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
What is the difference between passive stage and active stage?
What is the sortmerge collector?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
Teradata 
