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 last updated the row, createxid indicates the latest transaction for each row
  • To indicate deleted rows deletexid, assigned to each row is set to 0 if this is a readable (not a deleted row).  When the row gets deleted, this column gets populated with the transaction id assigned to the delete or update statement
  • Updates are essentially deletes that set the transaction id as deletexid to old row and createxid in the new row
  • Groom would make the soft deletes final

Typically, when you run a select you will not see rows that have a deletexid not equal to zero.  To change that, set the below option

set show_deleted_records = true

How to restore Netezza records

Here is a simple select statement:

select createxid,deletexid, * from table
Netezza Createxid and Deletexid

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

iOS

Reading Time: 2 minutes
Module 1: Introduction to Development MAC OS, IDE – XCODE, Interface Builder
      • Mac versions –Features
      • iOS versions -Features
      • Introduction to Xcode tool and Compilers
Module 2: Introduction to Objective-C
      • Creating Objective C classes and Methods
      • Creating Properties and methods
      • OOPS in Objective C
      • Inheritance ,Polymorphism,Dynamic Typing ,Dynamic Binding
      • Arrays,set,Dictionaries
      • Categories and protocols
      • Application Lifecycle
      • Xib,StoryBoard and Interface builder
      • Creating and building simple applications
      • UIState Preservation
      • View application sandbox and CrashLogs of Application
Module 3: Cocoa Design patterns
      • What is MVC ?
      • Model ,View and Controller Classes
      • Delegate and Datasource
      • Singleton Pattern
      • Observer pattern
      • Target-Action
      • Cocoa coding standards
Module 4: Memory Management
      • Introduction (alloc init,retain Release )
      • Auto release pool
Module 5: Objective -C ARC
      • Migrating your application to ARC
      • Basic Interaction with UIControls
      • Button,label,Textfields
      • switch,slider,progress bar
      • Alerts ∧ Action sheet
      • Tableviews
      • Scrollview, Web view,maps
      • SearchBar,popovers
      • Picker,Date picker,Imageview, Image picker controller
      • Gestures , Mouse events
      • Mail,Message,Phone call
Module 6: Orientation and iPhone sensors
      • The iPhone Accelerometer
      • Detecting shakes
      • Determining orientation
      • Responding to the accelerometer
Module 7: Working With TableView
      • UITableViewController
      • Working with multiple TableViews
      • UITableViewCell
      • TableView practices
      • CustomCell creation.
Module 8: Multi View Applications
      • view to view (Present model view controller )
      • Navigation controller
      • Tabbar controller
      • Pageview controller
      • Split view controller
Module 9: CoreGraphics and QuartzCore
      • UIKit and view lifeCycle
      • Draw lines and transforms.
      • Alphe ,Opaque ,hidden
      • Create PDF fiels
      • Merge Images
      • SplashView and Basic animation
      • Adding Views with animation
Module 10: Maps SDK
      • Introduction to MapKit Framework
      • Showing a simple Map
      • Update User Location
      • Background location updates of user .
Module 11: REST and SOAP services , XML and JSON Parsing
      • Asynchronous and synchronous request
      • Soap service
      • Rest service
      • Xml and JSON Parsing
      • KeyValue coding and Nested JSON objects
      • Error handling
      • Lazy loading
Module 12: MultiTasking in iOS
      • NSThread and management of multiple threads
      • Synchronous and Asynchronous
      • Introduction to NSTimers
      • GCD in iOS
      • NSOperation and NSOperationQueue
Module 13: Data Base Persistence
      • User Defaults
      • Plist
      • sqlite
      • Core Data
Module 14: Media interaction
      • AVAudio player
      • MedaiPlayer
      • MPMovie player
Module 15: Notifications
      • Local notifications
      • App level Notifications
      • Push Notifications
Module 16: Social Network Integration
      • FaceBook
      • Twitter
      • Google +
Module 17: Testing And Deployment
    • Debugging application in device.
    • iOS5,iOS6,iOS7 features and differences
    • App store Submission

Jquery

Reading Time: 3 minutes

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

    DB2 DBA UDB

    Reading Time: 3 minutes

    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

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

    Is Netezza near end of life?

    Reading Time: 3 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. 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.

    Model NameModel NumberGA DateEoM DateEoS Date
    SkimmerN100-104/11/201120/06/201430/06/2019
    Twinfin-3N1001-00204/11/201120/06/201430/06/2019
    Twinfin-6N1001-00504/11/201120/06/201430/06/2019
    Twinfin-12N1001-01004/11/201120/06/201430/06/2019
    Twinfin-24N1001-02004/11/201120/06/201430/06/2019
    Twinfin-36N1001-03004/11/201120/06/201430/06/2019
    Twinfin-48N1001-04004/11/201120/06/201430/06/2019
    Twinfin-72N1001-06004/11/201120/06/201430/06/2019
    Twinfin-96N1001-08004/11/201120/06/201430/06/2019
    Striper-3N2001-00501/02/201316/05/201430/06/2019
    Striper-6N2001-01001/02/201316/05/201430/06/2019
    Striper-12N2001-02001/02/201316/05/201430/06/2019
    Striper-24N2001-04001/02/201316/05/201430/06/2019
    Striper Gen 2N2002-00205/05/201530/06/201530/06/2020
    Striper Gen 2N2002-00505/05/201530/06/201530/06/2020
    Striper Gen 2N2002-01005/05/201530/06/201530/06/2020
    Striper Gen 2N2002-02005/05/201530/06/201530/06/2020
    Striper Gen 2N2002-04005/05/201530/06/201530/06/2020
    Mako 1/4 RackN3001-00217/10/201410/04/201810/04/2023
    Mako-3N3001-00517/10/201410/04/201810/04/2023
    Mako-6N3001-01017/10/201410/04/201810/04/2023
    Mako-12N3001-02017/10/201410/04/201810/04/2023
    Mako-24N3001-04017/10/201410/04/201810/04/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.
    Netezza migration options

    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.

    Complete Netezza Course
    Take your journey towards learning Netezza in just 30 days, just 1 hour a day. Joins 1000s  of others who have benefited by upskilling and boosting their careers
    Free Netezza Course
    Netezza TwinFin Arch.
    Learn about Netezza TwinFin Architecture and how it is unique
    TwinFin Architecture
    Sequences
    What are Sequences and how are they used to generate unique IDs
    Netezza Sequences
    Netezza Overview
    Quick introduction to what is Netezza and how is it used in Data Warehousing
    Netezza Overview
    nzstats command
    using nzstats to gather statistics and why is it useful
    nzstats

    SalesForce

    Reading Time: 5 minutes

    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

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

      Storage layers


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

      J2EE

      Reading Time: 3 minutes

      J2EE

        Module 1: JDBC

        • Introduction to JDBC
        • Databases and Drivers
        • Types of Driver
        • Loading a driver class file
        • Establishing the Connection to different
        • Database with different Driver
        • Executing SQL queries by ResultSet,Statements , PreparedStatment interface.
        • Using CallableStatement
        • Transaction Management & BatchUpdate
        • Programs/Interview related Question and Answer

        Module 2: JSP

        • Basics Of Jsp
        • Life cycle of JSP
        • JSP API
        • JSP in Eclipse and other IDE’s
        • Programs/Interview related Question and Answer.
        • Scripting Elements
        • scriptlet tag
        • expression tag
        • declaration tag
        • Implicit Objects
        • out
        • request
        • response
        • config
        • application
        • session
        • pageContext
        • page
        • exception
        • Directive Elements
        • page directive
        • include directive
        • taglib directive
        • Exception Handling
        • Action Elements
        • jsp:forward
        • jsp:include
        • Bean class
        • jsp:useBean
        • jsp:setProperty & jsp:getProperty
        • Displaying applet in JSP
        • Expression Language
        • What is expression and how to use it
        • Define expression and use over the service flow
        • The way to be achieve same in JSP
        • Mvc In Jsp
        • MVC pattern
        • Working flow implementation of MVC
        • CRUD operation using MVC
        • Design a real time web application using MVC
        • JSTL
        • Discussion on the tag library
        • How to implement and use
        • Custom Tags
        • Custom Tag : What and Why?
        • Custom Tag API?
        • Custom Tag Example
        • Attributes
        • Iteration
        • Custom URI

        Module 3: Servlet

        • Basics of Servlet
        • Servlet: What and Why?
        • Basics of Web
        • Servlet API
        • Servlet Interface
        • GenericServlet
        • HttpServlet
        • Servlet Life Cycle
        • Working with Apache Tomcat Server
        • Steps to create a servlet in Tomcat
        • How servlet works?
        • servlet in Myeclipse
        • servlet in Eclipse
        • servlet in Netbeans
        • Servlet request
        • Servlet Request methods
        • Registration example with DB
        • Servlet Collaboration
        • Request Dispatcher
        • send Redirect
        • Servlet Configure
        • Servlet Configure methods
        • Servlet Configure example
        • Servlet Context
        • Servlet Context methods
        • Servlet Context example
        • Session Tracking
        • Cookies
        • Hidden Form Field
        • URL Rewriting
        • HttpSession

        Module 4: Concurrent and implementation of collection

        • Implemenation of ArrayList
        • Implemenation of LinkedList
        • Implemenation of HashMap
        • Implementation of Queue/PriorityQueue/Deque

        Module 5: Advanced Multi-Threading

        • Implemenation of Executor pool service and working mechanism with real time
        • Big file(Single , multiple ) processing using multiple thread
        • Implemenation to achieve thread class and runnable interface

        Module 6: Javamail Api

        • Sending Email
        • Sending email through Gmail server
        • Receiving Email
        • Sending HTML content

        Module 7: Design Pattern

        • Singleton
        • DAO
        • DTO
        • MVC
        • Front Controller
        • Factory Method
        • Abstract

        Module 8: Junit

        • JUnit: What and Why?
        • Annotations used in JUnit
        • Assert class
        • Test Cases

        Module 9: Maven

        • Maven: What and Why?
        • Ant Vs Maven
        • How to install Maven?
        • Maven Repository
        • Understanding pom.xml
        • Maven Example
        • Maven Web App Example
        • Maven using Eclipse

        Module 10: Project Guidance

          Apache Spark

          Reading Time: < 1 minute

          Apache Spark

            Module 1: Introduction to Spark and Hadoop platform

            • What is Hadoop platform
            • Why Hadoop platform
            • What is Spark
            • Why spark
            • Evolution of Spark

            Module 2: Introduction to Scala

            • Functional Programing Vs Object Orient Programing
            • Scalable language
            • Scala Overview

            Module 3: SPARK Environment

            • Configuring Apache Spark

            Module 4: SCALA Enivronment

            • JAVA Setup
            • SCALA Editor
            • Interprepter
            • compiler

            Module 5: Deep Dive into Scala

            • Benefits of Scala
            • Language Offerings
            • Type inferencing
            • Variables
            • Functions
            • LOOPS
            • Control Structures
            • Vals
            • Arrays
            • Lists
            • Tuples
            • Sets
            • Maps
            • Traits and Mixins
            • Classes and Objects
            • First class functions
            • Clousers
            • Inheritance
            • Sub classes
            • Case Classes
            • Modules
            • Pattern Matching
            • Exception Handling
            • FILE Operations

            Module 6: Deep Dive into Spark

            • Spark Shell
            • Parallel Programming
            • context
            • RDD
            • Transformations
            • Programming with RDD
            • Actions
            • Broadcast Variables
            • Accumulators

            Module 7: Spark EcoSystem

            • Spark Streaming
            • MLlib
            • GraphX
            • Spark SQL