MENUS

Profile | LTL MESSAGE | HISTORY | Corporate Training | Corporate Training Clients |

Latest news

Links:

• Mainframe
• Dot Net
• JAVA
• Data Warehousing
• Testing

DATA WAREHOUSE(ETL TOOLS , INFORMATICA 8 ,DATASTAGE ,BUSSINESS OBJECTS DATA INTEGRATER):

DATA WAREHOUSE BASICS : .Data warehouse concepts .Sql,Pl/Sql,unix OS & Shell Scripting DATA WAREHOUSE METHODOLOGY : .Manage/Architect/Design phase,Build Phase .Deploy Phase/Operate Phase .Project Deliverabless and Documentations DATA MODELING : .Data Conceptual Modeling .User Views,Performance views modeling .Raiph Kimball design Methodology .Star schema/Snow Flake schema .Erwin Tool 4.0 INFORMATICA : PowerCenter 8 Level I Developer Track I This four day, instructor-led course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter releases 8.0 through lecture and hands-on exercises. Course Objectives After successfully completing this course, students should be able to: 1.Use PowerCenter 8 Designer to build mappings that move data from sources to targets 2.Use PowerCenter 8 Workflow Manager to build and run a workflow that runs a session based on a mapping 3.Design mappings and workflows based on business needs 4.Perform basic troubleshooting of PowerCenter mappings and transformaitons 5.Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 8 Course Agenda : Power Center: Terminology and Architecture Mapping Fundamentals Workflow Fundamentals Source Qualifier Source Qualifier Transformation Source Qualifier Joins Source Pipelines Expression, Filter Expression Editor Filter Transformation Joins, Features and Techniques I Joiner Transformation Lookups and Reusable Transformations Lookup Transformation Reusable Transformations Debugger Debugging Mappings Lab - Using the Debugger Sequence Generator Sequence Generator Transformation Sorter, Aggregator Sorter Transformation Aggregator Transformation Active and Passive Transformations Router, Update Strategy Router Transformation Update Strategy Transformation Expression Default Values Dynamic Lookup Dynamic Lookup Unconnected Lookup, Parameters and Variables Unconnected Lookup Transformation System Variables Mapping Parameters and Variables Mapplets Mapplets Workflow Design Designing Workflows Controlling Workflows Overview PowerCenter 8 Level I Developer Track II This five day, instructor-led course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter releases 8.0 through lecture and hands-on exercises. Course Objectives After successfully completing this course, students should be able to: 1. Use PowerCenter 8 Designer to build mappings that move data from sources to targets 2.Use PowerCenter 8 Workflow Manager to build and run a workflow that runs a session based on a mapping 3. Design mappings and workflows based on business needs 4. Perform basic troubleshooting of PowerCenter mappings and transformaitons 5. Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 8 Course Agenda : Power Center: Terminology and Architecture Mapping Fundamentals Workflow Fundamentals Source Qualifier Source Qualifier Transformation Source Qualifier Joins Source Pipelines Expression, Filter, File Lists and Workflow Scheduler Expression Editor Filter Transformation File Lists Workflow Scheduler Joins, Features and Techniques I Joiner Transformation Lookups and Reusable Transformations Lookup Transformation Reusable Transformations Debugger Debugging Mappings Lab - Using the Debugger Sequence Generator Sequence Generator Transformation Sorter, Aggregator and Self-Join Sorter Transformation Aggregator Transformation Active and Passive Transformations Self-Join Router, Update Strategy and Overrides Router Transformation Update Strategy Transformation Expression Default Values Source Qualifier Override Target Override Session Task Mapping Overrides Dynamic Lookup and Error Logging Dynamic Lookup Error Logging Unconnected Lookup, Parameters and Variables Unconnected Lookup Transformation System Variables Mapping Parameters and Variables Mapplets Mapplets Mapping Design Designing Mappings Workshop Workflow Variables and Tasks Link Conditions Workflow Variables Assignment Task Decision Task Email Task Worklets and More Tasks Worklets Timer Task Control Task Workflow Design Designing Workflows Controlling Workflows PowerCenter 8 Level II Developer Course Description : This five-day, instructor-led course complements and extends PowerCenter 8 Level I Developer with advanced topics and extended labs. The course is intended for developers with more than Three months of PowerCenter 8 experience. Topics covered include: Advanced Mapping Techniques; Advanced Workflow Techniques; Transaction Control; Workflow Recovery; Error Handling; Performance Tuning; Stored Procedures and Custom Transformations; Repository Reporting; Memory Allocation; and Pipeline Partitioning. PowerCenter 8 Level II Developer Objectives : After completing this course you should be able to: 1. Describe the PowerCenter 8 architecture 2.Given a mapping specification, build a corresponding mapping, using the techniques including: variables and parameter files; dynamic caching; data-driven and incremental aggregation; denormalization; user-defined and custom functions 3. Control workflow behavior with restart junctions, control tables, workflow variables, and dynamic scheduling 4. Configure workflows for recovery 5.Use transaction control to manage writing to targets 6.Configure PowerCenters handling of data errors 7.Manage objects in one or more repositories 8.Optimize PowerCenters memory usage 9.Using a standardized methodology, optimize the performance of PowerCenter in your environment 10. Use partitions and stages to improve performance PowerCenter 8 Level II Developer Agenda Module One: Architecture Overview and High Availability Architectural overview : 1. Domains, nodes, and services 2.Configuring services 3.High Availability Module Two: Mapping Specifications and Parameters 4.Velocity mapping specifications 5.Mapping parameters and variables 6.Parameter files 7.Normalizer Transformation Labs: Dynamically update mapping variable Create/use parameter files Module Three: Caching and Aggregation Dynamic lookup cache 1. Data driven aggregation 2.Incremental aggregation Labs: Dynamic Lookup Data-driven aggregation Incremental aggregation Module Three: Custom and User-Defined Functions 1.User-defined functions 2.Custom functions 3.Custom transformations Lab: User-defined functions Module 5: Controlling Workflow Execution 1. Timer and Email Tasks 2.Control Tasks 3.Restart Junctions 4.Alerts 5.Pseudo-Looping Labs: Using timer and control tasks; starting one workflow from another workflow Module 6: Dynamic Scheduling 1. Business Case 2.Workflow Variables 3.Assignment Task Lab: Workflow variables and assignment tasks Module 7: Workflow Recovery 1. Task recovery strategy 2.Session recovery strategy 3.Command task recovery strategy 4.Options in HA 5.States of operation 6.Repeatable data 7.pmcmd Lab: Configure for recovery and recover a suspended workflow Module 8: Transaction Control 1. Database Transactions 2.Transaction Control Transformation 3.Transformation Scope Lab: Use flags to control commit of invoice numbers Module 9: Error Handling 1. Row error categories 2.Error log options 3.Error handling strategies 4.Transaction control example Labs: rollback based on errors; write errorred rows to correct targets Module 10: Finding, Migrating, and Comparing Repository Objects 1. Object queries 2.Folder migration 3.Session migration 4.Deployment groups 5.Managing folder status 6.Rollback 7.Comparing objects Lab: Object queries Module 11: Repository Metadata 1. Repository Reports 2.Data Lineage 3.Metadata Exchange Module 12: Memory Optimization 1. Data Transformation Manager memory 2.Lookup transformation cache 3.Aggregator cache 4.Sorter cache 5.Joiner cache 6.Automatic memory attributes Module 13: Performance Tuning 1. Production environment 2.Bottlenecks and benchmarks 3.Identifying bottlenecks 4.Optimization 5.Target 6.Source 7.Mapping 8.Mapping/Session 9.Lookup example 10.Cached values and sequence generation 11. Performance counters Lab: Optimize an existing session Module 14: Pipeline Partitioning 1. Pipelines 2.Threads, partition points, and stages 3.Adding partitions 4.Partition types 5.Pipeline partitioning example 6.Dynamic partitioning Lab: Determine correct partitioning for existing sessions DataStage Essentials for Enterprise Edition (DX444) : Course outline: IBM WEBSPHERE Datastage Mod01: Introduction Introduction List and Describe the uses of Datastage List and Describe the Datastage clients Describe the Datastage Workflow List and Compare the different types of Datastage Jobs Describe the two types of parallelism exhibited by datastage Parallel Jobs IBM WEBSPHERE Datastage MOD02: Deployment Identify the components of Information servr that need to be installed Describe what a deployment domain consist of Decribe different domain deployment options Describe the installation process Start the information Server IBM WEBSPHERE Datastage MOD03: Administering Datastage Open the Administrative Console Create new users and Groups Assign Suite roles and Product roles to users and Groups Give users Datastage Credentials Log onto Datastage Administrator Add a Datastage user on the Permission tab and specify user's role Specify Datastage Global and project defaults List and Describe important environment variables IBM WEBSPHERE Datastage MOD04: Datastage Designer Log onto Datastage Navigate around Datastage Designer Import and Export Datastage objects to a File Import a Table Definition for a Seuential File IBM WEBSPHERE Datastage MOD05: Creating Parallel Jobs Design a simple Parallel Job in Designer Define Job Parameter Use theRow Generator,Peek and Annotation stages in a Job Compile your Job Run your job in Director view the Job Log IBM WEBSPHERE Datastage MOD06: Accessing Sequential Data Understand the stages for accessing different kinds of File data Sequential File Stage Data set Stage Create Job that read from and write to sequential Files Create Reject Links Work with NULLs in sequential files Read from Multiple files using file patterns Use Multiple Readers IBM WEBSPHERE Datastage MOD07: Platform Architecture Describe parallel Processing Architecture Describe pipeline paralelism Describe partition parallelism List and Describe partitioning and collecting algorithms Describe configuration files Describe the parallel Job compilation process Explain OSH Explain the Score IBM WEBSPHERE Datastage MOD08: Combining Data Combine data using Lookup stage Define range Lookups Combine data using merge stage Combine data using the Join Stage Combine data using the Funnel Stage IBM WEBSPHERE Datastage MOD09: Sorting and Aggregating Data Sort data using in-stage sorts and Sort Stage Combine data using Aggregator Stage Combine data Remove Duplicates Stage IBM WEBSPHERE Datastage MOD10: Transforming Data Use the Transformer stage in parallel Jobs Define constraints Define derivations Use Stage variables Create a parameter set and use its parameters in constraints and derivations IBM WEBSPHERE Datastage MOD11: Metadata Manager Perform a Simple Find Perform an Advanced Find perform an Impact Analysis Compare the differences between two Table Definitions Compare the difference between two Jobs IBM WEBSPHERE Datastage MOD12: Working with Relational Data Import Table Definitions for Relational Tables Create Data Connnections Use Connector Stage in a Job Use SQL BUILDER to define SQL Select statements Use SQL BUILDER to define SQL Insert and Update statements Use the DB2 Enterprise stage IBM WEBSPHERE Datastage MOD13: Metadata inthe parallel Framework Explain schemas Create Schemas Explain Runtime Column Propogation(RCP) Turn RCP on and Off Build a Job that reads data from sequential file using a Schema Build a Shared Container IBM WEBSPHERE Datastage MOD14: Job CoNTROL Use the datastage Job Sequencer to BUild job that controls a sequence of Jobs Ue Sequencer links and stages to control the sequence a set of jobs run in Use sequencer triggers and stages to control the conditions under which job runs Pass information in job parameter from master controlloing job to the controlled jobs Define user variable Enable restart Handle errors and exceptions IBM WEBSPHERE Datastage MOD15: Best Practices IBM WEBSPHERE Datastage MOD16: partitioners, parallel system variables, partitioning methods, partitioning methodology and recommendations, job score BUSSINESS OBJECTS DATA INTEGRATOR : Description: This two-day instructor-led course is designed to give learners the comprehensive skills and in-depth knowledge needed to create, analyze, and share WebIntelligence documents. Topics Covered: Introduction to WebIntelligence - Provides an overview of the BusinessObjects and WebIntelligence environment. Viewing a Document in InfoView - Describes how to log in to WebIntelligence, view some existing documents, and logout. It also explains how to get help, search for documents and configure the start page to your exact requirements. Creating New Documents with Queries - Describes how to use the WebIntelligence report panels to create, edit, and run queries, as well as save and print documents. It also describes how to create and assign categories to personal documents and how to configure list options and change your password. Restricting Data Returned by a Query - Describes how to apply and group filters to restrict the amount of data returned from the database. Displaying Information in Different Ways - Describes how to use tables and charts in WebIntelligence to display information in different ways. Enhancing the Presentation of a Report - Describes how to present data in a report, using different presentation styles and formatting options. Creating Formulas and Variables - Describes how to apply functions to your report. Analyzing Data at a Different Level - Describes how to analyze data in your reports from different levels of detail, and how to zoom in on important trends in your business. Sharing Documents - Describes how to distribute your WebIntelligence documents to colleagues Business Object Data Intergrator : Description: Using Data Integrator you can create jobs that Extract, Transform and Load (ETL) data from disparate sources to deliver more timely and accurate data that end users at your organization can trust. This course provides hands-on activities that walk you through setting a connection to your data source, creating and troubleshooting an ETL batch job, managing metadata, and using the Web Administrator to administer batch jobs. In this course you will also learn how to collaborate with others when creating ETL jobs in a multi-user environment As a business benefit, by being able to create efficient ETL jobs, your end users can use this transformed data to help improve operational and supply chain efficiencies, enhance customer relationships, create new revenue opportunities, and optimize your return on investment from enterprise applications. Who should attend? This course is designed for individuals responsible for implementing projects involving the extraction, transformation and loading of data in batch jobs, administering and managing projects that involve Data Integrator. What will I learn? After completing the course, learners will be able to: Describe BusinessObjects Data Integrator architecture Define source and target metadata to import into your ETL jobs Create a batch job Validate, trace and debug batch jobs. Use built-in Transforms and Functions to support data flow movement requirements Optimize data flow Use variables, parameters and Data Integrator Scripting Language Capture Changes in Data Handle errors and exceptions Support a multi-user environment, administer batch jobs and migrate projects using datastore and system configurations Manage metadata Course Topics Data Warehousing Concepts Describe normal forms of data Explain dimensional modeling Understanding Data Integrator Understand Data Integrator Architecture and Interface and

REPORTING TOOL(COGNOS,MICROSTRATEGY,BUSSINESS OBJECTS):

COGNOS : Course Detailed Description Overview of Data Warehousing What is Data Warehouse, Why do we need it Data Warehouse Architecture and its components Define Star Schema - Fact and Dimensions Understand OLTP and OLAP Systems Overview of Business Intelligence What is Business Intelligence Why is BI Important and where can we use it Components of BI Business Intelligence Roadmap Overview of Cognos 8.4 BI and Architecture Introduce Cognos 8 BI Examine the different studios in Cognos 8 BI Identify the different data sources within the studios Highlight key capabilities of Cognos 8 BI Understand Cognos Multi Layered architecture Cognos 8.4 Installations and Configuration Installing Cognos 8.4 Install Database (MS SQL) Install Framework Manager Install Cognos BI Application Setting up the Environment Configuring Cognos 8.4 Setting up Samples in Cognos 8.4 Uninstalling Cognos 8.4 Cognos 8.4 BI Administration Create and Modify a Data Source Create Database backups Understand Roles, Users and Groups Specify Permission Settings Cognos 8.4 Connection What is Cognos Connection Examine Cognos Connection UI elements - Create a URL, Login, Logoff Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties Navigation- Public and Private Folder Open reports with Report Name, Go to Links, Run Reports from a View Run Reports- Prompt Pages, Printing a report and Open in Excel View the run history of a report and Historical Reports Closing and Creating Quick links to Reports - My Folder Shortcut and Browser Bookmark Personalize Cognos Connection Backups- Export of Cognos, Content Store or select items for Backups Restore an exported Backup Create and Customize a Page and share a single page with Multiple Users Cognos 8.4 Query Studio Introduction to Query Studio Create Reports (List, Grouped List, Crosstab, Charts) Changing the Appearance of Reports (Format) Sorting and Grouping Filters and Prompts Subtotals and Calculations Run and Manage Reports Drill Through reports Cognos 8.4 Analysis Studio Introduction to Analysis Studio Creating a Basic Analysis Working with data in Crosstab Exploring Data Limiting Data Calculating Data Sharing Data Cognos 8.4 Report Studio Introduction to Report Studio Report Studio User Interface Creating, Save and Run Reports Report Templates Managing Reports Types of Reports List Reports Crosstab Reports Charts Formatting a Report Report Layout Guidelines Fonts, Styles, Header, Footer and Borders Insert objects Swap Columns and Rows Working with Data Filters, Parameters and Prompts Sorting and Grouping Subtotals and Calculations Working with Queries Working with Reports Managing changes in the Package Conditional Formatting Drill-through Reports Drill-up/Drill-down Reports Master-Detail Reports Scheduling Reports Cognos 8.4 Framework Manager (Metadata Modeling) Introduction to Framework Manager Framework Manager Basics User Interface, Navigation, Objects Planning the project and data model. Framework Manager Workflow Naming Conventions for objects in a project Designing Project Create project Importing Metadata from one and more sources Exporting Metadata Data Sources Working with Data Source Connections Create and Modify Data Sources Improve Performance by setting Query Processing Type Preparing Relational Metadata for use in Reports Verifying Relationships Working with Dimensions Working with Query Subjects- Data, Model and Stored Procedure Query Subject Working with Query Items- Set Usage and Aggregate Property Making Metadata Available to Report Authors Verify Model Set Governors Improving Performance Create or Modify Package Controlling access to Metadata Explore Package Publish Package Guideline for Modeling Metadata Best Practices - Presentation and Database layers Merge Metadata Perform Calculations and Filters Cognos 8.4 Event Studio What is Event Studio Define Parameter Define a Calculation Specify an Event condition Add a Report/Email Task Schedule an Agent Save and Run an Agent MicroStrategy : MicroStrategy Architect: Project Design Overview: In this two-day course, students will experience the power of the Micro Strategy suite by learning how to model and create a Micro Strategy project using Micro Strategy Architect. Participants will learn how to design a logical data model and learn how to translate a logical data model into various physical warehouse schemas. Students will also learn about the flexibility of Micro Strategy Architect to accommodate common data warehousing challenges. They will build a functional Micro Strategy project with MicroStrategy Architect that includes aggregate and partitioned fact tables. Attendees will leave with a complete understanding of what is required to build an effective Micro Strategy project that paves the way for a successful MicroStrategy reporting environment. MicroStrategy Products Covered: MicroStrategy Architect Who Should Attend: Project Designers Data Architects Database Administrators Prerequisites: MicroStrategy Desktop: Reporting Essentials course Introduction to MicroStrategy Architect The Logical Data Model The Physical Warehouse Schema Advanced Data Modeling and Schema Design Many-to-Many Relationships Joint-child Relationships Role Attributes Introduction to Project Creation in MicroStrategy Architect Creating MicroStrategy Facts Day Two Creating MicroStrategy Attributes Creating MicroStrategy Hierarchies Project Configuration Workshop Project Optimization and Maintenance Aggregate Tables Partitioning and Partition Mappings Transformations MicroStrategy Desktop: Advanced Reporting Overview: In this three-day course, participants will leave with a thorough understanding of the most powerful capabilities of MicroStrategy Desktop. Participants will learn about and create numerous types of advanced metrics including: level metrics, conditional metrics, non-aggregatable metrics, transformation metrics and custom metrics. In addition, students will explore the uses of custom groups and consolidations, as well as develop a solid understanding of the different types of filters and prompts, including relationship filters, joint element lists and dynamic date filters. Students will conclude the course learning about custom drill maps, advanced report data options and report developer tools and preferences. MicroStrategy Products Covered: MicroStrategy Desktop Who Should Attend: Report Developers or Report Designers Business Analysts who will be building advanced reports and have a working knowledge of SQL Project Technical Lead Consultants Power Users Prerequisites: MicroStrategy Desktop: Reporting Essentials course Introduction to Advanced Reporting Advanced OLAP Services Advanced Metrics Consolidations and Custom Groups Advanced Prompts Advanced Filters Drill Maps Report Data Options Report Developer Tools and Project/Desktop Preferences MicroStrategy Desktop: Reporting Essetials Overview: This two-day course provides students with an overview of the extensive reporting capabilities of MicroStrategy Desktop. Participants will leave with an understanding of report creation and the numerous data and style report manipulations in MicroStrategy Desktop, including auto-style creation, drilling, data pivoting, page-by, outline mode, grid and graph formatting, and thresholds. Additionally, participants will be versed in the creation of basic components that are essential in the creation of reports, including report filters, metrics, MicroStrategy OLAP Services features, prompts, and searches. Students will also u nderstand report design principles that leverage the capabilities of MicroStrategy Desktop. All lectures will be reinforced with hands-on exercises. MicroStrategy Products Covered: MicroStrategy Desktop Who Should Attend: Every Member of a MicroStrategy Project Team Business Analysts Power Users Anyone who wishes to attend additional MicroStrategy courses and certification Familiarity with using Windows interfaces Introduction to MicroStrategy Business Intelligence Introduction to MicroStrategy Desktop Creating and Saving Reports in Desktop Report Manipulations in Desktop Data Manipulations Style Manipulations Creating and Saving Basic Report Filters Creating, Formatting, and Saving Basic Metrics MicroStrategy OLAP Services in Desktop Report Objects View Filters Derived Metrics Creating and Saving Basic Prompts and Searches MicroStrategy Web: Report Design Overview: This one-day course is designed for MicroStrategy Web report designers who use the Web Professional version of MicroStrategy Web. Students will first learn about the Web Professional version of MicroStrategy Web. They will then learn how to create reports, report filters, and templates using Design Mode. The course covers the advanced report design features available in Web Professional. Finally, students will learn how to perform basic formatting changes to MicroStrategy Report Services documents in MicroStrategy Web. MicroStrategy Products Covered: MicroStrategy Web Who Should Attend: Report Developers Report Analysts Power Web End Users Prerequisites: MicroStrategy Web: Report Analysis course Topics: MicroStrategy Web for Report Designers Advanced Report Creation Creating and Saving Reports Creating Report Filters Saving Templates and Report Filters Advanced Save Options Advanced Report Design Advanced Grid Formatting Advanced Graph Formatting Modifying Documents Viewing Documents Inserting Basic Objects Formatting Objects MicroStrategy Web: Report Analysis Prerequisite course to: -MicroStrategy Web: Report Design Overview: This one-day course is designed for end users of MicroStrategy Web. Specifically, this course covers functionality available to users at the Web Reporter and Web Analyst levels. Students will leave with a thorough understanding of the power and flexibility of the MicroStrategy Web interface. Students will learn how to conduct basic and advanced analysis on reports and documents using MicroStrategy Web. They will also learn about basic report creation. Students will have the opportunity to practice with handson exercises for executing and manipulating reports and documents and formatting and creating reports in MicroStrategy Web. MicroStrategy Products Covered: MicroStrategy Web Who Should Attend: Web End Users Topics: Introduction to MicroStrategy Business Intelligence Introduction to MicroStrategy Business Intelligence Architecture Introduction to MicroStrategy Reporting Terminology Using the MicroStrategy Web Interface Introduction to the MicroStrategy Web Interface Executing Reports and Documents Basic Report Analysis in MicroStrategy Web Basic Report and Document Manipulations Basic Report Formatting Advanced Report Analysis in MicroStrategy Web Advanced Report and Document Manipulations Advanced Report Formatting Basic Report Creation in MicroStrategy Web Overview of Report Creation Creating Reports

TERADATA AND BUSINESS OBJECT TRAINING PROPOSAL :

Teradata Basic Workshop : Data Warehouse Basics What is Operational System, OLTP and why we need OLTP system ? What is a Data Warehouse? Comparison of OLTP Systems and Data Warehousing Why we require Data warehouse Platform for Retail Industry Explain about Data Warehouse Architecture, ODS , ETL , Terms in ETL, Archive / Backup Data , Metadata and how data warehouse Information Flows. Types Of Data Mart , Independent Data Mart ,Dependent Data Mart,Logical Data Mart Difference between Data Warehouse vs Data Mart , Pros and Cons What is Dimensional Data Modeling , Fact vs Dimensional Table. What is Star Schema/snow flake/ star Flake? Explaination about various Data Intergration and Business Intelligence Tools SQL Basics SQL Assistantce 6.2 Introduction to SQL ,ANSI vs. Teradata SQL , SQL commands Review of Relational Concepts A simple select statement, Order By Clause ,Multiple ORDER BY columns ,DISTINCT Option. Naming Rules Teradata Extensions SQL Request Processing HELP Tools , HELP command ,SHOW command Logical and Conditional Expressions , Logical Operators BETWEEN AND Numeric Range Test Operator Set Operator - IN, ANY,ALL,SOME OUTPUT Attributes such as AS For Renaming ,AS For Titles, FORMAT Option Teradata Architecture Detail explanation about Course Description ,Teradata Certification ,Additional Resources Teradata Product Overview , How Teradatas parallel architecture makes the processing of extremely large tables possible. Relational databases, data marts and data warehousing. What is Teradata , Teradata A Brief History , How Large is a Trillion? Designed for Todays Business , Evolution of Data Processing Teradatas Competitive Advantages , Teradata Manageability Review Questions Teradata Basics Teradata Storage Architecture Teradata Retrieval Architecture Multiple Tables on Multiple AMPs Linear Growth and Expandability Teradata Objects Data Dictionary Directory (DD/D) Teradata Features Review Review Question Teradata RDBMS Architecture Teradata Functional Overview Channel-Attached Client Software Overview Network-Attached Client Software Overview The Parsing Engine Message Passing Layer The Access Module Processor (AMP) Teradata Parallelism Review Questions Teradata Architecture Differences between Primary keys, Foreign keys, Primary Indexes, and Secondary Indexes, and how they are used in a Teradata system. Factors affecting data storage and distribution, and how data may be accessed for optimal performance using primary indexes, secondary indexes, and table scans. SQL Basics How to produce reports using complex joins, sub queries,aggregation and string manipulation of data. How to create tables and views using referential integrity constraints at both the column and table level. How to maintain data using INSERT, UPDATE and DELETE. How to create, debug and execute macros and how to pass run time parameters. How views and macros are used for security and control. How to use ANSI standard features such as the CASE statement, EXISTS statement, null handling, and date/time extraction. How to perform simple rankings on rows in a table, and extract samples of data from a table. HELP and SHOW commands to obtain information from the Data Dictionary/Directory about data structures associated with Teradata Database users, databases, tables, views, macros and indexes. Use of the Teradata DATE, TIME, TIMESTAMP and time ZONE data types for date and time-oriented queries. How to perform ANSI standard join processing including inner, outer, left, right, cross and product joins. Teradata Architecture Distinguish between a Teradata Database and Teradata User. How to Define Perm Space ,Spool space, Temp Space and explain how it is used. Visualize the hierarchy of objects in a Teradata system. System Variables and Keywords Difference between NCR system and Version V2R4 vs V2 R5 features SQL Basics Creating OLAP queries using advanced ranking functions such as RANK, QUANTILE, and WIDTH_BUCKET. Use of Ordered Analytic Functions for Group, Sum, Cumulative and Remaining Window Aggregations. Use of RANDOM and SAMPLE functions for generating data or extracting samples of existing data. Teradata Architecture How fault tolerance is integrated into the system to protect both data and applications from hardware and software failures. EXTERNAL LOADERS An overview of query submitting tools, application utilities, administrative tools, and programming tools available for use with Teradata systems Identify the Application Utilities. Describe how the Application Utilities interface with the Teradata database. State the advantage of using a utility over other access methods. SQL BASICS How and why to create and use volatile and global temporary tables. Creating tables with appropriate constraints for referential integrity and the controlling of data insertion. Implementing column compression for performance and reduced storage costs using single or multi-value compression. How to create new tables from existing tables and how to copy data and table attributes from the source table. ANSI standard features such as EXISTS statement, correlated subqueries, derived tables, null handling, and date/time extraction. External Loaders Basic Teradata Query (BTEQ) Use .EXPORT to SELECT data from the Teradata database to another computer. State the purpose of the four types of BTEQ EXPORT. Use .IMPORT to process input from a host-resident data file. Use Indicator Variables to preserve NULLs. Describe multiple sessions, and how they make parallel access possible. Workshop on BTEQ Scripts using BTEQ commands, Terdata SQL commands Workshop on BTEQ to use Fixed ,Delimited Files External Loaders FAST Load Utility Describe the two phases of FastLoad. Prepare a FastLoad script for populating empty tables from a Fixed Width File and variable field length File. Partition a data load over successive runs. Restart an interrupted FastLoad. Workshop on Fast Load Scripts using FLOAD commands, Terdata SQL commands Workshop on Fast Load how to prepare a re-runnable scripts. Workshop on Fast Load utility how to use multiple input files to load a single table using Multiple fast load jobs. Workshop on fast load restorability procedures and scenarios Fast Export Utility After completing this module, you will be able to provide State FastExport capabilities. Describe how sorted output is produced from a multiple-session SELECT. Prepare a FastExport script Workshop on Fast Export utility how to export data from teradata table for various formats. Workshop on Fast Export Utility how to prepare scripts , External Loaders Multi Load Utility After completing this module, you will be able to Describe the capabilities of MultiLoad. Name the five phases of MultiLoad and state the main function of each. Create a MultiLoad script. Run a script to update/load table(s) using MultiLoad. Explain the advantages of using MultiLoad. Describe the tables involved in a MultiLoad job. Set error limits as a time value or as a percentage of loaded rows. Specify a checkpoint interval. Redefine input record layout. Workshop on preparing MLOAD Scripts by applying Match tags and field Indicators. Workshop on preparing MLOAD scripts for Multiple table (Max of Five Tables ) Workshop on MLOAD to use MLOAD IMPORT and DELETE task. Data warehouse Project After completing this project , students will be able to understand the full capabilities of Loaders and SQL commands Salestrak project which has eight different flat files is used to populate Data mart . Analyze the Source Files , Prepare Source to target mapping document. Develop appropriate scripts (BTEQ,FLOAD,MLOAD) based on requirements to parse, validate, cleanse , apply business rules and perform Load strategy for both fact and dimension tables.