 |
| TERADATA,TIBCO,OBIEE,Data Stage,CognosTM1 ,XCELSIUS,LIVEOFFICE,CRYSTAL REPORT ONLINE TRAININGS - JOB SUPPORT |
| TERADATA,TIBCO,OBIEE,Data Stage,CognosTM1 ,XCELSIUS,LIVEOFFICE,CRYSTAL REPORT ONLINE TRAININGS - JOB SUPPORT |
Number of Views :
27 |
Training Center / Institute Name :
NAIPUNYA |
About the Institute :
TERADATA
Module 1:
- Understand the Teradata Scalable Architecture
- Understand how data is stored in Teradata
- Describe how data gets into/out the system
- Describe what the main components of Teradata are
- Overview of Teradata Utilities & Tools
- Use Teradata HASH functions for analyzing data placement
– Primary & Secondary Indexes (Fundamentals)
- Identify Primary Index Choice criteria
- Describe uniqueness and how it affects space utilization
- Explain row access, selection and selectivity
- Choose between single and multi
-column Primary Indexes
- Describe single Nun
-Unique Secondary Index (NUSI) access.
- Descript Dual NUSI Access
- Explain NUSI and Aggregate Processing
- Compare NUSI vs. Full Table Scan (FTS)
- Access Considerations & Locking Mechanisms
- Analyze Optimizer Access scenarios
- Explain partial value searches and data conversions
- Identify the effects of conflicting data types
- Describe different LOCK scenarios
Module 2:
- Explain the Explain
- Secondary Index Usage
- Fundamental Tools
- Join Optimization
- Collecting Statistics
- ETL Denormalization
- Enhanced Indexing
- Aggregation
- CASE Statement
- Between dates comparison
- Upsert
- Count & Distinct
- Show
- Drop / Create vs. Delete All
- Derived, Volatile, Global
- Referential Integrity processing
- Qualification
- CASTING For better JOINS
Naipunya,
Behind Venkatadhri Theater,
Dillsukhnagar,
Hyderabad
Andhra Pradesh-500 036
9573488558
|
Trainings :
Online
|
Address / Colony:
Naipunya,
Behind Venkatadhri Theater,
Dillsukhnagar,
Hyderabad
Andhra Pradesh-500 036
9573488558
Dillsukhnagar |
City :
Hyderabad |
Contact Person :
Yogendra |
Phone No:
9573488558 |
Contact Institute
(This Institute got
0 email Responses so far)
|
Student /
Training Center
