Tags » Netezza

Microsoft's big freaking servers make cloud wars even more interesting

So much news so little time.

On this week’s Structure Show we talk about Microsoft’s latest cloud moves including the beefiest cloud servers known to man (so far, but give it a second); a new Azure-in-a-box appliance– which Microsoft hopes will do better than its last attempt. 166 more words

Advanced Security in an Insecure Data World

“Customer data may be at risk” is an all too familiar corporate acknowledgement these days, a communication event no enterprise wants to face.  Target lost personal information from at least 40,000,000 customers, stolen by thieves in late 2013.  651 more words

IBM PureData

Former Netezza Team Reunites And Lands $8M To Solve Today's Big Data Problem

In 2000, some companies had big data problems before the concept we know today even existed. Back in those days, these organizations used a concept called the data warehouse to deal with large amounts of data, and a company called… 571 more words

TC

very useful information about Netezza

ERROR:  to_timestamp(): bad value -26 for day of the month.

Solution:-  Check the format defined.

Ex:- Selectto_timestamp(‘2002-09-26^15:00:00′,‘YYYY-MMDD^HH24:MI:SS’)

Correction Select to_timestamp(‘2002-09-26^15:00:00′,‘YYYY-MM-DD^HH24:MI:SS’)

If you see the above function usage, the timestamp passing and defined don’t match (highlighted in different color) 341 more words

Netezza

Repeat Records multiple times based on some column

Oracle Query to Repeat a Number n Times

below are the scenarios using oracle hierarchy query’s (ex:- 

START WITH and CONNECT BY, Level etc.,)


Scenario:- 268 more words

Netezza

LAST_VALUE() AND FIRST_VALUE() best example

Scenario:-

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day.

SOURCE_PHONE_NUMBER

DESTINATION_PHONE_NUMBER

CALL_START_DATETIME

1234

4567… 156 more words

Netezza