• 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

The post AWS Glue (Serverless ETL) appeared first on iExpertify.

Related posts:

Overview of AWS Glue Traditional ETL vs AWS Glue Some use cases for using AWS Glue

CREATE EXTERNAL TABLE ‘C:\\Users\\MyUser\\Account dim dump.csv’ USING ( DELIMITER ‘,’ Y2BASE 2000 ENCODING ‘internal’ REMOTESOURCE ‘JDBC’<OR>'ODBC' ESCAPECHAR ‘\’ ) AS select Query here with multiple complex joins

The post Local External Tables Netezza appeared first on iExpertify.

set show_deleted_records = true

select createxid,deletexid, * from table

If you want to see just the deleted rows , just select where deletexid is not zero

select createxid,deletexid, * from table where deletexid !=0

Once you can see your deleted data, and figure out which transaction you are trying to undo, you can simply re-insert the data

insert into table
select * from table where deletexid=142233; –transaction id from delete.

To undo an update, just re-insert the deleted rows and delete the inserted rows.

insert into table 
select * from table where deletexid=146443 ;–transaction id from update
delete from table where createxid=146443; –transaction id from update

To undo an insert, use the below SQL

delete from table where createxid=1434443; –transaction id from insert

The post Netezza CREATEXID DELETEXID appeared first on iExpertify.

The post iOS appeared first on iExpertify.

JQuery

Module 1: jQuery Introduction

• Target Background
• References
• Unit Topics
• What Is jQuery?
• Benefits of Using a JavaScript Library
• jQuery Example
• CSS Selectors
• How to Use jQuery
• Practical Usage Notes
• Background – DOM
• Background – DOM Ready Events
• Background – JavaScript Functions
• The jQuery Function Object
• What Does the $() Function Take as Argument?
• What Does the $() Function do?
• The jQuery Wrapper
• The jQuery Wrapper as an Array-Like Object
• Note: innerHTML() vs. .html()
• jQuery Wrapper Chaining
• API Function Notation
• Handling DOM Ready Event
• xhtml Note

Module 2: Selectors

• Background: The Sizzle Selector Engine
• Selecting Elements by Attribute
• Pseudo-Selectors
• Form Pseudo-Selectors
• Faster Selection
• Selecting Elements Using Relationships
• Selecting Elements Using Filters
• More on Chaining: .end()
• Testing Elements
• Is the Selection Empty?
• Saving Selections
• Iterating Through Selected Elements Using .each()
• JavaScript Methods
• JavaScript “this”
• Function Context
• The Function call() Method
• .each() Revisited

Module 3: Style Class Manipulation

• Two Options
• Specifying Style Properties
• Setting Style Properties
• .addClass() / .removeClass()
• Defining a Stylesheet
• Setting & Getting Dimensions
• Attributes

Module 4: DOM Manipulation

• The $ Function Revisited
• Getters and Setters
• The text() Element Method
• Appending DOM Elements
• Removing DOM Elements
• Performance

Module 5: Events

• Event Overview
• Old School: Event Handling Using HTML Element Attributes
• Unobtrusive JavaScript
• Unobtrusive JavaScript Example
• Multiple Handlers
• Using jQuery Wrapper Event Registration Methods
• The .bind() Method
• Event Propagation
• Handlers for Elements Before They Exist!
• The Event Object
• Triggering Events

Module 6: Utility Functions

• The jQuery Object Revisited
• Functions May Have Methods
• A jQuery Utility Function: $.trim()
• $.each()
• Example jQuery Utility Functions

Module 7: Ajax

• Ajax Overview
• The Browser & the Server
• The Ajax Request
• The Ajax Response
• Sending an Ajax Request With jQuery – The General Case
• When this code is executed…
• Sending an Ajax Request With jQuery – Simpler, Typical Case
• Data Types
• The .data() method

Module 8: Advanced Ajax

• A Form Example
• An Ajax Form Example
• Serialize()
• Get vs. Post
• More on Query Strings
• ajaxStart() and ajaxError()

Module 9: Animations and Effects with jQuery and jQuery UI

• What is jQuery UI?
• Can I do Animations and Effects using jQuery only?
• Hiding Elements with jQuery
• Using .hide() and .show() in jQuery
• Alternating an Element’s Visibility in jQuery
• Adjusting the Speed in jQuery
• Providing a Handler in jQuery
• Using .slideUp() / .slideDown() methods in jQuery
• jQuery UI Categories
• jQuery UI Interactions: Droppable and Draggable
• Droppable and Draggable More Complete Exampl
• jQuery UI Widgets: Datepicker
• jQuery UI Widgets: Autocomplete

Module 10: Parsing JSON

• JSON
• Reading JSON from the Server Using Ajax
• Example file contents
• Using the Results
• Optimized Version
• Getting More From the Response
• jqXHR Methods
• POST vs. GET
• Invalid JSON
• Using $.ajaxSetup()

Module 11: Plugins

• What is a plugin?
• Goal
• Self-Executing Anonymous Functions
• Meeting Our Goal
• Prototype Objects
• The jQuery Wrapper Class Revisited
• Example Plugin
• Using the Plugin

The post Jquery appeared first on iExpertify.

DB2 DBA UDB

Module 1: Overview of DB2 9.7 on Windows
• Contrast the DB2 Family of products
• Identify the DB2 Tools
• Functions of DB2 components
• Explore installation and parameters

Module 2: Command Line Processor (CLP) & GUI Usage

• Use the Command Line Processor
• Explore the GUI environment
• Describe the DAS role with GUI tools

Module 3: The DB2 Environment

• Key features of an Instance
• Create and drop an Instance
• Use db2start and db2stop
• Distinguish b/w types of Config.
• Describe and modify the Database Manager Configuration

Module 4: Creating Databases and Data Placement

• Creating a Database.
• Explore system Catalog tables, views
• Compare DMS Vs SMS table Spaces.
• Database with Automatic Storage.
• Differentiate between table spaces, containers, extents, and pages
• Define table spaces
• Get snapshot for table spaces
• Explore Database Config. Parameter.

Module 5: Creating Database Objects

• List DB2 object hierarchy and physical directories & files
• Creating objects: Schema, Table, View, Alias, and Index
• Explore the use of table partitioning
• Review the use of Temporary Tables
• Implementation of Check Constraints, Referential Integrity and Triggers
• Exploring the use of Large Objects

Module 6: Moving Data

• Discuss the INSERT statement and Recognize its limitations
• Explain the differences between IMPORT and LOAD
• Explain the EXPORT, IMPORT, and LOAD syntax
• Create and use Exception Tables and Dump-Files
• Distinguish and Resolve Table States: Load Pending and Set Integrity Pending
• Use the SET INTEGRITY command
• Discuss the db2move and db2look commands

Module 7: Backup And Recovery

• Describe the major principles and methods for backup and recovery
• State the three types of recovery used by DB2
• Explain the importance of logging for backup & recovery
• Describe how data logging takes Place –circular & archival logging
• Use the BACKUP, RESTORE, and ROLLFORWARD commands
• Perform a table space backup and recovery
• Restore a database to the end of logs or to a point-in-time
• Backup and recovery scenarios

Module 8: Locking And Concurrency

• Explain why locking is needed
• List objects that can be locked
• Describe and discuss the various lock modes and their compatibility
• Explain four different levels of data protection
• Set isolation level and lock time out for current activity
• Explain lock conversion & escalation
• Describe causes of Deadlocks

Module 9: Problem Determination

• Collect information for problem analysis and resolution
• Use error logs for basic problem analysis
• Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor and Health Monitor
• Basic commands to better work with connections and Sessions
• Retrieve statistics and information from a running DB2 instance

Module 10: Application Issues and Performance

• Prepare applications that access DB2 data for execution
• Describe the application alternatives available to access DB2 data
• Define the concept of clustering, and determine the proper cluster sequence
• Use RUNSTATS, REORGCHK, and REORG to enhance application performance
• Work with the EXPLAIN facility

Module 11: Security

• Use Access Control Mechanisms to implement database security
• Use group IDs to create a control hierarchy
• Describe Label Based Access Control
• Describe privileges within a database
• Describe privileges required for binding and executing a package
• Describe the difference between explicit privileges & implicit privileges
• Describe the different level of authorization

The post DB2 DBA UDB appeared first on iExpertify.

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 all the objects in the databases. It also passes and verifies the queries from the clients, generates executable snippets, communicates the snippets to the S- Blades, coordinates and consolidates the snippet execution results and communicates back to the client.

Snippet Processing Array: SPA is an array of S-Blades with 8 processor cores and 16 GB of memory running Linux operating system. Each S-Blade is paired with Database Accelerator Card which has 8 FPGA cores and connected to disk storage.

Snippet Processor: The CPU and FPGA pair in a Snippet Processing Array called a snippet processor which can run a snippet which is the smallest code component generated by the host for query execution.

The post Host, SPA in Netezza appeared first on iExpertify.

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. Additionally, 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.

IBM is not extending support

IBM is NOT offering an extended support service beyond their announced end-of-support date. When Netezza devices are reaching end of life, some companies are choosing to temporarily support it with their existing team without help from IBM until the final strategic solution is in place. Also, there are 3rd parties who are supporting service for these devices. examples are

1. https://www.natrinsic.com/netezza/?hsLang=en
2. Data Warehouse Support Services with Smart Associates (smart-associates.biz)

Most are finding a replacement

Most companies I know are finding a replacement solution and migrating their data warehouses. Snowflake or Redshift are the two most common choices I have heard. What are your companies migrating toward?

Staying with IBM Netezza

What happened to Netezza? – Journey to AI Blog (ibm.com)

Read the blog entry from IBM. They are not strategically moving away from Netezza technology itself. But the popular Netezza appliance that enabled a lot of companies achieve their Data warehousing strategy is changing. They are suggesting these 2 major alternatives:

• IBM® Netezza® Performance Server for the cloud – support current workloads but is adapted for cloud performance
• For on premises, in the IBM Cloud Pak® for Data System hyperconverged architecture, Netezza Performance Server clients connect to the Netezza Performance Server host, which runs as a Docker container named ipshost1 on the system Control Plane node.

Move to the cloud

In conclusion, most solutions are moving toward cloud workloads and if your industry is still hesitant to move towards cloud due to regulatory, privacy or lesser control, you could find on premises alternatives. Most client I have heard of are moving to AWS (Redshift) or Snowflake on (AWS or Azure) as IBM stops support and trying to get you into their IBM cloud solution.

The post Is Netezza near end of life? appeared first on iExpertify.

SalesForce

Module 1 : Salesforce Overview

• Learning Objectives
• Introduction to Salesforce
• Salesforce Editions
• Home page Customization
• User Management
• Creating and Customizing Tabs
• Creating an App
• Uploading a Company Logo
• Company Information Page
• System Overview Page
• Updating the Fiscal Year
• Case study
• Key Takeaways

Module 2 : Salesforce Objects

• Learning Objectives
• Standard Object Components
• Renaming Standard Objects
• Modifying Standard Objects
• Understanding External Objects
• Creating Custom Objects
• Case study
• Key Takeaways

Module 3 : Field Types

• Learning Objectives
• Modifying Standard Fields
• Creating Auto-Number Fields
• Creating Formula Fields
• Creating Roll-Up Summary Fields
• Creating Lookup and Master-Detail Fields
• Creating Checkbox Fields
• Creating Currency, Number, and Percent Fields
• Creating Date Fields and Date and Time Fields
• Creating Phone and Email Fields
• Creating Geolocation Fields
• Creating Picklist and Multi-Select Picklist Fields
• Creating Text and Text Area Fields
• Creating Text Area Long and Text Area Rich Fields
• Considerations for Field Type Change
• Field Deleting Implications
• Creating Encrypted Fields
• Creating URL Fields
• Case study
• Key Takeaways

Module 4 : Validation Rules

• Learning Objective
• Creating Validation Rules
• Creating Formulas
• Creating Error Messages
• Case study
• Key Takeaways

Module 5 : Security Controls

• Learning Objective
• Viewing Object Security
• Changing Default Record Access
• Sharing Settings
• Field Accessibility
• Password Policies
• Session Settings
• Login Flows
• Network Access
• Activations
• Session Management
• Login Access Policies
• Certificate and Key Management
• Viewing Setup Audit Trail
• Executing Expire All Passwords
• Delegated Administrations
• Remote Site Settings
• Named Credentials
• File Upload and Download Security
• Case Study
• Key Takeaways

Module 6 : Profiles

• Learning Objective
• Overview of Standard Profiles
• Assigning Page Layouts
• Field-Level Security
• Custom App Settings and Access
• Tab Settings
• Record Type Settings
• Administrative Permissions
• General User Permissions
• Standard Object Permissions
• Custom Object Permissions
• Password Policies and Session Timeout
• Login Hours and IP Ranges
• Enabling Apex and Visualforce Access
• Case Study
• Key Takeaways

Module 7 : Role Hierarchy

• Learning Objective
• Viewing Role Hierarchy
• Creating Roles
• Enabling Field History
• Creating Groups
• Creating Permission Sets
• Assigning Roles to Users
• Case Study
• Key Takeaways

Module 8 : Workflow Rules

• Learning Objective
• Creating a Workflow Rule
• Creating a Workflow Rule Field Update
• Creating a Workflow Rule Task Assignment
• Creating a Workflow Rule Email Alert
• Outbound Message
• Time-Dependent Workflow Action
• Time-Dependent Workflow Action – Considerations
• Overview of Approval Process
• Components of an Approval Process
• Case Study
• Key Takeaways

Module 9 : Data Management

• Learning Objective
• Importing Leads
• Data Import Wizard
• Importing Contacts and Accounts
• Using Mass Delete
• Installing Data Loader
• Installing Data Loader
• Importing Records with Data Loader
• Updating Records with Data Loader
• Deleting Records with Data Loader
• Exporting Records with Data Loader
• Adding a Field in the Schema Builder
• Scheduling a Data Export
• Creating and Using Sandbox
• Mass Transferring Records
• Reporting Snapshots
• Working with Tags
• Case Study
• Key Takeaways

Module 10 : Reports

• Learning Objective
• Understanding Report Formats
• Tabular Reports
• Summary Reports
• Matrix Reports
• Join Reports
• Creating Leads Report
• Creating Contacts and Accounts Report
• Creating an Opportunity Report
• Adding Leads to a Campaign from a Report
• Creating a Report Chart
• Scheduling Reports
• Creating a Campaign Report
• Summarizing Report Data
• Creating a Report Formula
• Exporting Reports to Excel
• Date Filters
• Bucket Fields
• Custom Report Types
• Case Study 1
• Case Study 2
• Key Takeaways

Module 11 : Dashboards

• Learning Objective
• Understanding Dashboard Components
• Creating a Dashboard
• Refreshing a Dashboard
• Modifying Columns on Dashboards
• Adding Filters to a Dashboard
• Managing Access to Reports
• Adding a Report as a Dashboard Component
• Setting Up Dynamic Dashboards
• Enabling Dashboards for iPad
• Modifying Report and Dashboard Interfaces
• Activating the Report Builder on Profiles
• Case Study
• Key Takeaways

Module 12 : Chatter

• Learning Objective
• Chatter Overview
• Enabling Chatter
• Enabling Chatter Feeds on Records
• Configuring Chatter Groups
• Creating Customer Groups
• Creating a Free Customer Chatter User
• Customizing Chatter Email Notifications
  Configuring Salesforce to Salesforce

• Accepting a Salesforce Connection
• Sharing an Account via Salesforce to Salesforce
• Enabling Ideas
• Configuring Idea Themes
• Enabling Social Accounts
• Enabling Libraries and Content
• Customizing Libraries and Content
• Uploading Documents to Libraries and Content
• Configuring Salesforce1
• Case Study
• Key Takeaways

Module 13 : Change Sets and Deployment

• Learning Objective
• Outbound Change Sets
• Inbound Change Sets
• Deployment Settings
• Deployment Status
• Eclipse IDE
• Case Study
• Key Takeaways

Module 14 : Application Lifecycle

• Learning Objective
• Key Milestones and Considerations
• Using Sandboxes for Development
• Using Change Sets
• Using Unmanaged Packages
• Case Study
• Key Takeaways

Module 15 : Visual Workflow, Process Builder, and Schema Builder

• Learning Objective
• Creating a Visual Flow
• Modifying Existing Flows
• Creating a Process in the Process Builder
• Creating Fields in the Schema Builder
• Case Study
• Key Takeaways

Module 16 : Lightning Components

• Learning Objective
  Installing Lightning Components

• Lightning Component Capabilities
• Lightning Components vs. Visualforce
• Case Study
• Key Takeaways

Module 17 : Creating Buttons, Links, and Actions

• Learning Objective
  Global Action

• Object Specific Action
• Object Specific Action – Types
• Action Layout in Salesforce1
• Creating New Records with Actions
• Logging a Call with Actions
• Updating a Record with Actions
• Creating Custom Buttons
• Creating Custom Links
• Case Study
• Key Takeaways

Module 18 : Sales Cloud

• Learning Objective
• Leads Home Page
• Creating List Views
• Creating and Converting Leads
• Creating Accounts
• Creating Contacts
• Creating Email Templates
• Four Sales Productivity Features
• Sending Individual Emails
  Sending Mass Emails

• Creating and Managing Price Books
• Creating Products
• Creating Opportunities
• Creating Activities
• Creating a Web-to-Lead Form
• Creating a Lead Assignment Rule
• Creating a Lead Queue
• Creating an Auto-Response Rule
• Creating Campaigns
• Record Types
• Case Study 1
• Case Study 2
• Key Takeaways

Module 19 : Quote Templates

• Creating a Quote Record
• Creating a Quote Template
• Generating a Quote PDF
• Emailing a Quote PDF
• Modifying Quote Templates
• Case Study
• Key Takeaways

Module 20 : Service Cloud

• Learning Objective
• Creating Cases
• Creating Case Assignment Rules
• Creating Case Escalation Rules
• Enabling Solutions
• Creating Solutions
• Attaching Solutions to Cases
• Enabling Knowledge
• Configuring Knowledge
• Creating a Web-to-Case Form
• Create an Email-to-Case Address
• Case Study 1
• Case Study 2
• Key Takeaways

Module 21 : – Communities

• Creating a New Community
• Partner Portal
• Customer Portal
• Communities
• Topic Management
• Reputation Management
• Adding Members
• Managing Tabs and Branding
• Login and Registration
• Community Preferences
• Case Study
  Key Takeaways

Module 22 : User Interface

• Learning Objective
• User Interface General Options
• User Interface Sidebar Options
• User Interface Calendar Options
• User Interface Name Settings
• User Interface Setup Options
• Case Study
• Key Takeaways

Module 23 : Help and Training

• Using Answers
• Using Ideas
• Searching for a Help Topic
• Contacting Support
• Trust Site
• Known Issues
• Case Study
• Key Takeaways

Module 24 : AppExchange

• Learning Objective
• AppExchange Overview
• Finding and Selecting an App
• Finding a Developer
• Finding a Consultant
• Case Study
• Key Takeaways

Module 25 : Other Important Concepts

• Learning Objective
• SalesforceA
• SalesforceA – Actions
• Salesforce and Outlook – Integration
• Many-to-Many Relationship
• Many-to-Many Relationship — Example
• Self Relationship
• Hierarchy Relationship

The post SalesForce appeared first on iExpertify.

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 dataslice
2. 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, intermediary results, etc.

• When we use temporary tables, it is this third partition, the temp space, that we risk filling up.
• It is important to only create the minimum number of temporary tables needed at a time. It is also important to only make the temporary tables as large as needed.
• Temporary tables are local to a session rather than a specific query. This means that the table may be used repeatedly within a user session. That is the major difference between Temporary tables (multiple use) and derived tables (single use). A Temporary table is materialized in swap space. However, it is not discarded until the session ends or when the user manually drops it.

When explicitly creating large temporary tables used in JOINs it is recommended to GENERATE STATISTICS on the temporary table.

The post Netezza Temporary Table Space appeared first on iExpertify.