Skip navigation

Manage categories

Close

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

Categories in Prospective Users
Add a new category (0 remaining)

Manage Announcements

Close

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

Announcements in Prospective Users
Subject Author Date Actions

Welcome to the Prospective Users Community

This community is for you to discuss current topics in Data Warehousing, Business Intelligence, new technologies, industry trends, etc. with others of like interests.

 

If you are an owner of a Netezza Performance System, please use the Users Community to discuss best practices and other technical issues.

Recent Activity

Refresh this widget
Gary Gary replied to Continuously load into Netezza

"We are doing loads every minute of 4 different files (about 100k records in total across all 4). Seems to work fine, but we do have to be ca"

in Prospective Users 3 replies
3 days ago
xgo xgo replied to Continuously load into Netezza

"We created a group for the reporting user that has Resource allocation minimum set to 50% (u can set this in nzadmin).   That will reserve"

in Prospective Users 3 replies
3 days ago
nickg nickg replied to Continuously load into Netezza

"You still need to do micro-batches, it is just that you are doing them more frequently.  Performance hit will all depend on how much data yo"

in Prospective Users 3 replies
4 days ago
Tamir Tamir started the discussion Continuously load into Netezza

"Hi,   We would like to load continuously data into Netezza. We are getting great results loading data every hour but our business needs req"

in Prospective Users 0 bookmarks
4 days ago
Tamir Tamir replied to count distinct uniques

"Thanks Shawn"

in Prospective Users 2 replies
1 week ago
Shawn Fox Shawn Fox replied to count distinct uniques

"Is this an actual problem or a hypothetical one?  I'm not sure exactly what you are trying to do, but one thing that can often help performa"

in Prospective Users 2 replies
2 weeks ago
Tamir Tamir started the discussion count distinct uniques

"Hello Everyone,   We are facing interesting challenge of how to count unique user id's in our system for any given timestamp. Logically it"

in Prospective Users 0 bookmarks
2 weeks ago
Jordan Chernev Jordan Chernev replied to Distribution keys that have null values

"Just playing devil's advocate and arguing Nick's point. The query has a 100% success rate of profiling your data where the NULLFRAC depends"

in Prospective Users 10 replies
3 weeks ago
Gregory Primosch Gregory Primosch replied to Distribution keys that have null values

"NULLFRAC will tell you the percentage of records with NULL values for that column. See above."

in Prospective Users 10 replies
3 weeks ago
nickg nickg replied to Distribution keys that have null values

"Why not do a simple select count(*) where your column of interest is NULL?"

in Prospective Users 10 replies
3 weeks ago
DON DON replied to Distribution keys that have null values

"Greg, I am trying to figure out what distribution columns has null values? I am able to figure out what distribution column accept null val"

in Prospective Users 10 replies
3 weeks ago
Gregory Primosch Gregory Primosch replied to Distribution keys that have null values

"Don, sorry I don't understand the question.   In general, it seems like a very bad practice to distribute your columns on a nullable field"

in Prospective Users 10 replies
3 weeks ago
DON DON replied to Distribution keys that have null values

"So how you justify if you have null values in distribution keys based on NULLFRAC results?"

in Prospective Users 10 replies
4 weeks ago
DON DON started the discussion Netezza developer needed

"Hello; We needed Netezza ETL developer who has good understanding of data loading. Knowledge of informatica is big plus.   Let me know if"

in Prospective Users 0 bookmarks
4 weeks ago
Gregory Primosch Gregory Primosch replied to Distribution keys that have null values

"Jordan, NULLFRAC is the fraction of records that are NULL for this attribute."

in Prospective Users 10 replies
4 weeks ago

Popular Documents

Subject Author
Enzee Events 5 months ago by Administrator Administrator