DATASTAGE - Online Training for SAP|Oracle|JAVA|Microsoft|Mobile Apps|Testing|SAS|Hadoop - Acutesoft Solutions
India:+91 (0)9848346149, USA: +1 973-619-0109, UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

DATASTAGE ONLINE TRAINING

DATASTAGE ONLINE TRAINING IN INDIA, USA & UK

DATASTAGE ONLINE TRAINING IN CANADA

DATASTAGE ONLINE TRAINING IN AUSTRALIA

DATASTAGE ONLINE TRAINING

DATASTAGE COURSE CURRICULUM

Download [PDF]

    • Overview of the Data Stage
        Introduction to Data Warehousing
        What is Data Warehousing?
        Who needs Data Warehousing?
        Why Data Warehouse is required?
        Types of Systems (OLTP, DSS, OLAP)
        Maintenance of Data Warehouse
        Data Warehousing Life Cycle

      >

    • Data Warehousing Architecture
        Source
        Integration Layer
        Staging Area
        Target
        Analysis & Reporting
        IBM WEBSHPERE DATA STAGE VERSION 8.1 Contents
        Introduction about Data Stage
        IBM Information Sever architecture
        Datastage within the IBM Information Sever architecture
        Difference between Server Jobs and Parallel Jobs
        Difference between Pipeline and Partition Parallelism
        Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto)
        Configuration file
        Difference between SMP/MPP Architecture
        Data stage components (Server / Client components)
        Package installer

      >

    • Using Controls
        Layouts
        Phase and Checkpoint
        Project and Sandbox
        Sub graphs
        Deadlocks
        Continuous Flows
        Interpreting the Log File
        Monitoring the Graph
        Wrapper Scripts
        Brief intro about EME
        Brief intro about Shop For Data (SFD)
        Brief intro about Conduct>It
        Brief intro about Data Profiler

DATASTAGE

DataStage is a powerful Extraction, Transformation, and Loading tool. DataStage has the following features to aid the design and processing:

      • Uses graphical design tools. With simple point-and-click techniques you can draw a scheme to represent your processing requirements
      • Extracts data from any number or type of database
      • Handles all the metadata definitions required to define your data warehouse or migration. You can view and modify the table definitions at any point during the design of your application
      • Aggregates data. You can modify SQL SELECT statements used to extract data
      • Transforms data. DataStage has a set of predefined transforms and functions you can use to convert your data. You can easily extend the functionality by defining your own transforms to use.

IBM WebSphere DataStage TX delivers the ability to easily and seamlessly automate high-volume, complex transactions without the need for additional coding-resulting in a quick return on investment.

IBM WebSphere DataStage TX 6.7 delivers rapid ROI through a highly scalable, open architecture.

IBM WebSphere DataStage TX allows you to: >br /> Quickly and seamlessly integrate many of the most popular applications, databases, and messaging systems Respond quickly and with flexibility to rapidly evolving, strategic business requirements Leverage the value of your enterprise systems and applications Meet your project-based or full integration solution needs

IBM WebSphere DataStage Features & Benefits
IBM WebSphere DataStage provides these unique capabilities: The Most Powerful ETL Solution – Supports the collection, integration and transformation of high volumes of data, with data structures ranging from simple to highly complex. DataStage manages data arriving in real-time as well as data received daily, weekly or monthly.

The Most Scalable Platform
Enables companies to solve large-scale business problems through high-performance processing of massive data volumes. By leveraging the parallel processing capabilities of multiprocessor hardware platforms, DataStage Enterprise Edition can scale to satisfy the demands of ever-growing data volumes and stringent real-time requirements and ever shrinking batch windows

The Most Comprehensive Source and Target Support
Supports a virtually unlimited number of heterogeneous data sources and targets in a single job, including: text files; complex data structures in XML; ERP systems such as SAP and PeopleSoft; almost any database (including partitioned databases); web services; and SAS.

Real-time Data Integration Support
Operates in real-time capturing messages from Message Oriented Middleware (MOM) queues using JMS or WebSphereMQ adapters to seamlessly combine data into conforming operational and historical analysis perspectives. IBM WebSphere RTI Services is a service-oriented architecture (SOA) enabling middleware that brokers enterprise-wide the benefits of the Ascential Enterprise Integration Suite across a continuum of time constraints, application suites, interface protocols and integration technologies.

Advanced Maintenance and Development
Gives developers maximum speed, flexibility and effectiveness in building, deploying, updating and managing their data integration infrastructure. Full data integration reduces the development and maintenance cycle for data integration projects by simplifying administration and maximizing development resources.

DEMOS VIDEOS

UPCOMING DEMOS

For updated Schedules please contact
calls