Row out of sequence
Posted: Thu Nov 13, 2003 12:00 pm
-----Original Message-----
From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
Sent: Thursday, October 16, 2003 8:47 AM
To: 'datastage-users@oliver.com'
Subject: Row out of sequence
I'm pulling in data from a DB2 source table with 2 lookups to a hash file
and another database table, I'm then sorting and aggregating but keep on
getting the following error:
DMSSalesFactStar..Aggregator_30: Row out of sequence
At row 5, link "SalesFactToAggregate"
Row out of sequence
..........can anyone suggest anything, cheers.
Regards,
Sanjeev
---------------------------------------------------------
Mobile: +44 (0) 7780 60 44 39
---------------------------------------------------------
=======================================================
This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst & Young Group. It is intended only
for the person to whom it is addressed. If you are not the intended
recipient, youare not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all copies
of this message.
=======================================================
From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
Sent: Thursday, October 16, 2003 8:47 AM
To: 'datastage-users@oliver.com'
Subject: Row out of sequence
I'm pulling in data from a DB2 source table with 2 lookups to a hash file
and another database table, I'm then sorting and aggregating but keep on
getting the following error:
DMSSalesFactStar..Aggregator_30: Row out of sequence
At row 5, link "SalesFactToAggregate"
Row out of sequence
..........can anyone suggest anything, cheers.
Regards,
Sanjeev
---------------------------------------------------------
Mobile: +44 (0) 7780 60 44 39
---------------------------------------------------------
=======================================================
This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst & Young Group. It is intended only
for the person to whom it is addressed. If you are not the intended
recipient, youare not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all copies
of this message.
=======================================================