Skip navigation

Manage categories

Close

Create and manage categories in Users. Removing a category will not remove content.

Categories in Users
Add a new category (0 remaining)

Manage Announcements

Close

Create and manage announcements in Users. Try to limit the announcements to keep them useful.

Announcements in Users
Subject Author Date Actions

Welcome to the Netezza Users Community

This is a customer-to-customer environment where NPS users of all levels of expertise collaborate to inquire, contribute to and gain knowledge about the Netezza Performance Server (NPS). Please use this platform to share any documents or thoughts that you feel will benefit the members of the Customer community.

Recent Activity

Refresh this widget
Jordan Chernev Jordan Chernev replied to factrel planner not working

"I've helped the planner get a better execution plan by adding a mview on the fact table. That being said, the process recommendation is prob"

in Users 9 replies
16 hours ago
Jordan Chernev Jordan Chernev replied to Start learning Netezza

"venky, I think you may need a customer login to either the website or to Netezza's FTP for the actual pdfs. If you're lucky, they may be ava"

in Users 7 replies
16 hours ago
Shawn Fox Shawn Fox replied to Column reference "TABLE_NAME" is ambiguous

"This appears to be a regression.  I'm not sure if it is specific to the Emulator.  You can get around this by using a different syntax (it i"

in Users 2 replies
18 hours ago
nickg nickg replied to Column reference "TABLE_NAME" is ambiguous

"Sounds like a bug in the emulator."

in Users 2 replies
20 hours ago
Shawn Fox Shawn Fox replied to Emulator available again (formally known as Netezza Simulator)

"You can get help for the Emulator by emailing them at ndnsupport at wwpdl.vnet.ibm.com   You can just start the Emulator directly from vmwa"

in Users 2 replies
21 hours ago
Mary Keegan Mary Keegan asked Column reference "TABLE_NAME" is ambiguous

"Hi, I have come across the error                ERROR:  Column reference "TABLE_NAME" is ambiguous when trying to run a query in the netez"

in Users 0 bookmarks
22 hours ago
clbrad clbrad replied to Emulator available again (formally known as Netezza Simulator)

"Hi Shawn,   The emulator installation and implementation was very easy.  Thanks!  I have been able to successfully start and connect to the"

in Users 2 replies
22 hours ago
Jordan Chernev Jordan Chernev replied to CPU/IO usage in Twinfin 12

"Probably at the switch level for those ports that are connected to the rest of your servers/network.   I'm not sure about the internal fabr"

in Users 7 replies
1 day ago
Ian Wu Ian Wu replied to factrel planner not working

"Thanks, will try it out,  And I think you and Nick made a very good point, I probably should load the missing data into the ref table in the"

in Users 9 replies
4 days ago
Ian Wu Ian Wu replied to factrel planner not working

"Agree, but tables used in this query is a part of ELT process where data is in an intermediate stage before reaching that perfect dimensiona"

in Users 9 replies
4 days ago
Shawn Fox Shawn Fox replied to factrel planner not working

"You might try using:   set enable_left_outerjoin = off;  Probably will not work, but it is worth a shot.  You may want to log an issue as I"

in Users 9 replies
4 days ago
nickg nickg replied to factrel planner not working

"One key rule in dimensional design is fact table foreign keys always reference a row.  It is standard practice to include 'unknown' rows in"

in Users 9 replies
4 days ago
Ian Wu Ian Wu replied to factrel planner not working

"Yes. The statistics on those table are up-to-date."

in Users 9 replies
4 days ago
Ian Wu Ian Wu replied to factrel planner not working

"Thanks.   Yes, I tried with inner join and it does give me the plan I want, but unfortunately I have to do left join because I need to get b"

in Users 9 replies
4 days ago
Shawn Fox Shawn Fox replied to Swap partition event alert setup

"There is no supported way to see how much space is left for transient tables for a Netezza-1000 (TwinFin) system."

in Users 4 replies
4 days ago

Popular Documents

Subject Author
IsNumber Function Equivalent 3 years ago by rrshep rrshep