Hi guus,
i was extracting employee table from the source and passed through aggregator stage and then used odbc to store the data.
soure table has columns. target too has the same colums.
empno
ename
salary
in the aggregator stage- i want to find the sum of sal.
so double click the sal column.
in the derivation i have choosen the aggregate function sum.
i double click the column deptno and i have given groupby.
similarly did with the other columns too.
didn''t do with the sal column, since i need to find the sum(sal).
the peculiar problem iam getting is NO DERIVATION FOR COLUMN EMPNO.
but i have double click the column empno and have choosen group by.
why am i getting this type of error. plz help me.
cheers;
vijaykumar
regarding aggregator stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the derivation window (double click on the Derivation field) you specify the input column - the drop-down list on the left hand side - and either check the "group by this column" check box or choose an aggregate function from the right-hand drop-down list.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi gurus,
i was able to compile th ejob without errors, but now iam getting a different error. when i click the tab- view data in source.
iam getting the error.
SQL STATE=SO22,DBMSCODE=904
[DATASTAGE][SQL CLINET][ODBC][ORACLE][ODBC][ORA]-00904.
SCOTT.EMP.EMPNO,EMPNAME INVALID IDENTIFIERS.
cheers;
vijaykumar
i was able to compile th ejob without errors, but now iam getting a different error. when i click the tab- view data in source.
iam getting the error.
SQL STATE=SO22,DBMSCODE=904
[DATASTAGE][SQL CLINET][ODBC][ORACLE][ODBC][ORA]-00904.
SCOTT.EMP.EMPNO,EMPNAME INVALID IDENTIFIERS.
cheers;
vijaykumar
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Why are you posting under a different user name? Have you hijacked the other person's user id?
Or do you guys belong to a team? Confusing
The error you are getting is from Oracle and not from DataStage.
Here's what the error means from google.
Whale.
Or do you guys belong to a team? Confusing
The error you are getting is from Oracle and not from DataStage.
Here's what the error means from google.
Code: Select all
ORA-00904: string: invalid identifier
Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: