AWS Glue (Serverless ETL)

Reading Time: < 1 minute

Introduction Traditional ETL vs AWS Glue Overview of AWS Glue Demo: Creating a ETL solution using AWS Some use cases for using AWS Glue Summary What to read next? Overview of AWS Glue Traditional ETL vs AWS Glue Some use cases for using AWS Glue

Local External Tables Netezza

Reading Time: < 1 minute

If your query build a large set of results and takes a long time to run (an hour or more), try using local external tables. Based on what tool you are using: JDBC SQL tool such as Squirrel or a ODBC tool such as Aginity CREATE EXTERNAL TABLE ‘C:\\Users\\MyUser\\Account dim dump.csv’ USING ( DELIMITER ‘,’… Continue reading Local External Tables Netezza

Published
Categorized as learn Tagged

Netezza CREATEXID DELETEXID

Reading Time: 2 minutes

Note: TRUNCATING TABLE cannot be UNDONE Note: Netezza “soft” deletes until the groom process runs.  i.e. deleted data is really still there.   Note: Netezza Updates are just soft deletes and inserts. So, they can be recovered too Every insert, update, or delete transaction is assigned a sequential transaction id or xid. To indicate which transaction… Continue reading Netezza CREATEXID DELETEXID

Published
Categorized as learn Tagged

iOS

Reading Time: 3 minutes

Contents for iOS

Published
Categorized as Full Course

Jquery

Education mechanism concept, abstract background with connected gears and icons for elearning, knowledge, learn, analytics, network, social media and global concepts, creative brain, Idea concept, vibrant color, service, analytics, technology, research, seo, media, social networking, digital marketing, communicate concepts, digital marketing,digital communication - Concept. Very easy to manipulate, elements are on a different layers.Vector infographic illustration, EPS 10.

Reading Time: 3 minutes

Contents for Jquery

Published
Categorized as Full Course

DB2 DBA UDB

Reading Time: 3 minutes

Contents for DB2 DBA UDB

Published
Categorized as Full Course

Host, SPA in Netezza

Reading Time: < 1 minute

Key terms and terminologies used in the context of Netezza appliance. Host: A Linux server which is used by the client to interact with the appliance either natively or through remote clients through OBDC, JDBC, OLE-DB etc. Hosts also store the catalog of all the databases stored in the appliance along with the meta-data of… Continue reading Host, SPA in Netezza

Published
Categorized as learn

Is Netezza near end of life?

Reading Time: 2 minutes

Appliances that end of support

IBM has announced the end-of-support (EOS or End-of-life) dates for three generations of Netezza / IBM PureData analytics appliances

Netezza Skimmer, Twinfin, Striper models have already passed their EOS date before the mid of 2020. Mako models will reach end of support by October 2023.

Published
Categorized as learn Tagged

SalesForce

Reading Time: 5 minutes

Contents for SalesForce

Published
Categorized as Full Course

Netezza Temporary Table Space

Reading Time: 2 minutes

In IBM PureData System for Analytics, each disk is roughly equally divided into 3 partitions:1. The first partition holds the primary copy of one dataslice2. The second partition holds a mirror copy of a dataslice from a different disk.3. The temp partition is used to store data that is generated during query execution. Temporary tables,… Continue reading Netezza Temporary Table Space

Published
Categorized as learn Tagged