Hi,
I'am having 2 inputs in Aggreagator Stage
i. PERSON_K (Integer)
ii. SRC_EFF_Y (Date)
Sort method has kept to Hash
Partitioning set to Auto.
Column is grouped by 'Person_K' & calculation is done for SRC_EFF_Y.
i.,e Max. value output column
I have changed the column name at the o/p of aggregator stage to the other than what I have in i/p i.,e SRC_EFF_Y_TEST
But still getting Fatal error as
Agg: Error when checking operator: When binding input interface field "SRC_EFF_Y" to field "SRC_EFF_Y": No default type conversion from type "date" to type "dfloat".
Thanks
Max of date from Aggregator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All Aggregator stage calculation columns generate data type dfloat.
Try converting the date to Julian and getting the max of that, then converting back to any desired date format.
Try converting the date to Julian and getting the max of that, then converting back to any desired date format.
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.
-
- Premium Member
- Posts: 288
- Joined: Tue May 27, 2008 3:42 am
- Location: Luxembourg
Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution.
On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine... No more warnings / aborts.
Basically what happens I guess is on choosing to preserve the datatype the output of the aggregator remains in iys source format.
On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine... No more warnings / aborts.
Basically what happens I guess is on choosing to preserve the datatype the output of the aggregator remains in iys source format.
Tony
BI Consultant - Datastage
BI Consultant - Datastage