The following link describes the markup tags that are accepted by this community. Please use these tags when posting in Plain Text -
http://www.netezzacommunity.com/markuphelpfull.jspa
Thank you for your contribution
Expiring the announcement will not delete it but will remove it from the public announcement list. Are you sure you want to expire this announcement?
Are you sure you want to delete this announcement?
Create and manage categories in Prospective Users. Removing a category will not remove content.
Create and manage announcements in Prospective Users. Try to limit the announcements to keep them useful.
| Subject | Author | Date | Actions |
|---|
Enter your announcement details below, including when you would like it to become active and expire. By default, announcements will become active immediately and expire in 7 days.
Loading...
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.
|
|
Gary replied to
"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 replied to
"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 replied to
"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 started the discussion
"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 replied to
"Thanks Shawn" in Prospective Users • 2 replies |
1 week ago |
|
|
Shawn Fox replied to
"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 started the discussion
"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 replied to
"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 replied to
"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 replied to
"Why not do a simple select count(*) where your column of interest is NULL?" in Prospective Users • 10 replies |
3 weeks ago |
|
|
DON replied to
"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 replied to
"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 replied to
"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 started the discussion
"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 replied to
"Jordan, NULLFRAC is the fraction of records that are NULL for this attribute." in Prospective Users • 10 replies |
4 weeks ago |
| Subject | Author | ||
|---|---|---|---|
|
|
Re: Continuously load into Netezza 3 days ago | by Gary |
|
|
|
Re: Distribution keys that have null values 3 weeks ago | by Jordan Chernev |
|
|
|
Re: count distinct uniques 1 week ago | by Tamir |
|
|
|
Re: Hi all, Can somebody please throw some light into how netezza handles simultaneous multiple updates to same table? 2 years ago | by Paras |
|
|
|
Re: TRIM not working 3 years ago | by Shawn Fox |
|

