Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Important Netezza Statistic Offset by 1

More
31 Mar 2017 15:05 #1 by Virginie_Samson
Netezza Statistic Offset by 1 was created by Virginie_Samson
Hello
Since we use Stambia on Netezza, we always have an offset by 1 beween what is Insert in the database, and what is written in the statistics.
Do you know where it come from ?
Exemple :
Select count(*) from MyTable -> 3418
Stambia Statistics : SUM(SQL_STAT_INSERT) = 3417

Thanks for your hep
Virginie
More
04 Apr 2017 15:56 #2 by risson
Replied by risson on topic Netezza Statistic Offset by 1
Does it happen also when there is no source data ? => you get statistic = 1 ?
Maybe there is a special query before the INSERT in the SqlOperation ?
More
05 Apr 2017 17:17 #3 by Virginie_Samson
Replied by Virginie_Samson on topic Netezza Statistic Offset by 1
No, it's 0, when there is no data
More
16 Aug 2017 10:59 #4 by Virginie_Samson
Replied by Virginie_Samson on topic Netezza Statistic Offset by 1
Hello
Did you find out the problem ?

Thanks