-----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.
=======================================================
Row out of sequence
Row out of sequence
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Row out of sequence
-----Original Message-----
From: Timothy Walsh [mailto:Tim.Walsh@york.com]
Sent: Thursday, October 16, 2003 8:54 AM
To: datastage-users@oliver.com
Subject: RE: Row out of sequence
Within the Aggregator, have you identified a "Sort Order" in the input
link, under the columns tab. If you have, then you have to guarantee
that the data is sorted in that order. Otherwise, the aggregator will
give you an "out of sequence" error.
Tim
-----Original Message-----
From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
Sent: Thursday, October 16, 2003 3:47 PM
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: Timothy Walsh [mailto:Tim.Walsh@york.com]
Sent: Thursday, October 16, 2003 8:54 AM
To: datastage-users@oliver.com
Subject: RE: Row out of sequence
Within the Aggregator, have you identified a "Sort Order" in the input
link, under the columns tab. If you have, then you have to guarantee
that the data is sorted in that order. Otherwise, the aggregator will
give you an "out of sequence" error.
Tim
-----Original Message-----
From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
Sent: Thursday, October 16, 2003 3:47 PM
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.
=======================================================
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Row out of sequence
-----Original Message-----
From: Ray Wurlod [mailto:rayw@mindless.com]
Sent: Thursday, October 16, 2003 6:04 PM
To: datastage-users@oliver.com
Subject: RE: Row out of sequence
To put it less generously, you were caught lying to the Aggregator stage!
:D
You probably want to include an ORDER BY clause in the SELECT statement, to
ensure that the data are sorted as you specify on the Aggregator stage's
input link.
----- Original Message -----
From: "Timothy Walsh"
Date: Thu, 16 Oct 2003 15:54:09 +0200
To:
Subject: RE: Row out of sequence
> Within the Aggregator, have you identified a "Sort Order" in the input
> link, under the columns tab. If you have, then you have to guarantee
> that the data is sorted in that order. Otherwise, the aggregator will
> give you an "out of sequence" error.
>
> Tim
>
> -----Original Message-----
> From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
> Sent: Thursday, October 16, 2003 3:47 PM
> 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: Ray Wurlod [mailto:rayw@mindless.com]
Sent: Thursday, October 16, 2003 6:04 PM
To: datastage-users@oliver.com
Subject: RE: Row out of sequence
To put it less generously, you were caught lying to the Aggregator stage!
:D
You probably want to include an ORDER BY clause in the SELECT statement, to
ensure that the data are sorted as you specify on the Aggregator stage's
input link.
----- Original Message -----
From: "Timothy Walsh"
Date: Thu, 16 Oct 2003 15:54:09 +0200
To:
Subject: RE: Row out of sequence
> Within the Aggregator, have you identified a "Sort Order" in the input
> link, under the columns tab. If you have, then you have to guarantee
> that the data is sorted in that order. Otherwise, the aggregator will
> give you an "out of sequence" error.
>
> Tim
>
> -----Original Message-----
> From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
> Sent: Thursday, October 16, 2003 3:47 PM
> 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.
> =======================================================
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Row out of sequence
-----Original Message-----
From: David Barham [mailto:David.Barham@Anglocoal.com.au]
Sent: Thursday, October 16, 2003 6:20 PM
To: 'datastage-users@oliver.com'
Subject: RE: Row out of sequence
When you say "sorting and aggregating", do you mean separate stages or do
you mean all using the aggregator stage? I suspect you are trying to do it
all in the aggregator stage (which is OK, but read on ...)
If you read the manual carefully (and do a little reading between the
lines), the sort order properties are used to tell the aggregator stage that
the data is ALREADY sorted so that it can use this information to run more
efficiently. At first glance, it might seem that it is specifying the order
you want it sorted in, but that is not the case.
If the data presented to the aggregator stage is not sorted, then don't
specify anything in the sort order properties. The aggregator stage will
then sort the data itself in order to do the aggregation.
However, if volumes are high and performance becomes an issue, you might
want to look at other alternatives for sorting the data before presenting it
to the aggregator stage. As Ray suggested, if you can sort it in the input
query (assuming the lookups values are not part of the sort order), that
should be more efficient.
-----Original Message-----
From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
Sent: Thursday, 16 October 2003 11:47 PM
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.
=======================================================
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
From: David Barham [mailto:David.Barham@Anglocoal.com.au]
Sent: Thursday, October 16, 2003 6:20 PM
To: 'datastage-users@oliver.com'
Subject: RE: Row out of sequence
When you say "sorting and aggregating", do you mean separate stages or do
you mean all using the aggregator stage? I suspect you are trying to do it
all in the aggregator stage (which is OK, but read on ...)
If you read the manual carefully (and do a little reading between the
lines), the sort order properties are used to tell the aggregator stage that
the data is ALREADY sorted so that it can use this information to run more
efficiently. At first glance, it might seem that it is specifying the order
you want it sorted in, but that is not the case.
If the data presented to the aggregator stage is not sorted, then don't
specify anything in the sort order properties. The aggregator stage will
then sort the data itself in order to do the aggregation.
However, if volumes are high and performance becomes an issue, you might
want to look at other alternatives for sorting the data before presenting it
to the aggregator stage. As Ray suggested, if you can sort it in the input
query (assuming the lookups values are not part of the sort order), that
should be more efficient.
-----Original Message-----
From: Johal, Sanj S [mailto:sanj.johal@cgey.com]
Sent: Thursday, 16 October 2003 11:47 PM
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.
=======================================================
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.