
softwarecabbges.com

-
Claimed Profile
Some amazing things about us you should know.
-
0+Students
-
6+Courses
-
12+Total Instructors
-
1+Services offered
About softwarecabbges.com
We are providing Informatica online training by industry experts.
Based on Industry demand we are offering TERADATA 13 FREE FOR INFORMATICA.
- INFORMATICA POWER CENTER 9 + TERADATA 13 FREE:
- QA
ORACLE SQL/PLSQL
UNIX BASICS
INFORMATICA POWER CENTER 9 + TERADATA 13 FREE:
Description:
The Course teaches the fundamentals of Informatica Power center 9 platforms, through online training and numerous hands-on lab exercises. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them successful Power center developers. Providing Training Material Support PPT s & Pdf Docs and Softwares.
Data Warehouse Concepts:
- Introduction to Data warehouse
- What is Data warehouse and why we need Data warehouse
- OLTP vs ODS vs Data warehouse
- Dimensional modeling
- Star schema/Snowflake schema/Galaxy schema
- Dimensions / Facts tables.
- Slowly Changing Dimensions and its types.
- Data Staging Area
- Different types of Dimensions and Facts.
- Data Mart vs Data warehouse
- DWH Approaches: Ralph Kimball’s vs Bill Inmon’s
Informatica Power Center 9:
Software Installation:
Informatica 9 Server/Client Installation on Windows/Unix.
Power Center Architecture and Components:
- Introduction to informatica Power Center
- Difference Between Power Center and Power Mart
- PowerCenter 9 architecture
- PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture
- Extraction, Transformation and loading process
- Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration Console.
- Repository Server and agent
- Repository maintenance
- Repository Server Administration Console
- Security, Repository, privileges and folder permissions
- Metadata extensions
Power Center Developer Topics:
Lab 1- Create a Folder.
How to provide Previllages
Source Object Definitions
-
- Source types
1. Relational Tables (Oracle, Teradata)
2. Flat Files (fixe width, Delimiter Files)
3. Xml Files
4. Cobol Files
5. SalesForce
-
- Source properties
Lab 2- Analyze Source Data, Import Source.
Target Object Definitions
- Target types
- Target properties
Lab 3- Import Targets
Transformation Concepts
- Transformation types and views
- Transformation features and ports
- Informatica functions and data types
Mappings
- Mapping components
- Source Qualifier transformation
- Pre SQL and Post SQL
- Mapping validation
- Data flow rules
Lab 4 –Create a Mapping, session, and workflow
Workflows
- Workflow Tools
- Workflow Structure and configuration
- Workflow Tasks
- Workflow Design and properties
Session Tasks
- Session Task properties
- Session components
- Transformation overrides
- Session partitions
Workflow Monitoring
- Workflow Monitor views
- Monitoring a Server
- Actions initiated from the workflow Monitor
- Gantt chart View and Task view.
Lab 6 – Start and Monitor a Workflow
Debugger
- Debugger features
- Debugger windows
- Tips for using the Debugger
Lab 7 –The Debugger
Expression transformation
- Expression, variable ports, storing previous record values.
Different type of Ports
Input/ output / Variable ports and Port Evaluation
Filter transformation
- Filter properties
Lab 8- Expression and Filter
Aggregator transformation
- Aggregation function and expressions
- Aggregator properties
- Using sorted data
- Incremental Aggregation
Joiner transformation
- Joiner types
- Joiner conditions and properties
- Joiner usage and Nested joins
Lab 9 – Aggregator, Heterogeneous join
Working with Flat files
Importing and editing flat file sources & Targets
Lab Session – Use Flat file as source.
Sorter transformation
- Sorter properties
- Sorter limitations
Lab 10 – Sorter
- Propagate Attributes.
- Shared Folder and Working with shortcuts.
- Informatica built in functions.
Lookup transformation
- Lookup principles
- Lookup properties
- Lookup techniques
- Connected and unconnected lookups.
- Lookup Caches
Lab 11 – Basic and Advance Lookup
Target options
- Row type indicators
- Row loading operations
- Constraint- based loading
- Rejected row handling options
Lab 12 – Deleting Rows
Update Strategy transformation
Update strategy expressions
Lab 13 – Data Driven Inserts and Rejects
Router transformation
- Using a router
- Router groups
Lab 14 – Router
Conditional Lookups
- Usage and techniques
- Advantage
- Functionality
Lab 15 – Straight Load
Lab 16 – Conditional Lookups
Heterogeneous Targets
- Heterogeneous target types
- Target type conversions and limitations
Lab 17 – Heterogeneous Targets
Mapplets
- Functionality and Advantages
- Mapplet types and structure
- Mapplet limitations
Lab 18 – Mapplets
Reusable transformations
- Advantages
- Limitations
- Promoting and copying transformations
Lab 19 – Reusable transformations
Sequence Generator transformation
- Using a sequence Generator
- Sequence Generator properties
Dynamic Lookup
- Dynamic lookup theory
- Usage and functionality
- Advantages
Lab 20 – Dynamic Lookup
Concurrent and sequential Workflows
- Concurrent Workflows
- Sequential Workflows
- Stopping, Starting and suspending tasks and workflows
Lab 21 – Sequential Workflow
Additional Transformations
- Union Transformation
- Rank transformation
- Normalizer transformation
- Custom Transformation
- Transformation Control transformation
- XML Transformation
- SQL Trasnformation
- Stored Procedure Transformation
- External procedure Transformation
- SQL Transformation
Lab Sessions- For above transformations
Error Handling
• Overview of Error Handling Topics
Lab 22 – Error handling fatal and non Fatal
Workflow Tasks:
- Command
- Decision
- Timer
- Control
- Even Raise and Wait
- Sequential Batch Processing
- Parllel Batch Processing
Lab Sessions – With Workflow tasks
Link Conditions
Team Based Development
- Version Control
- Checking out and checking in objects.
Performance Tuning
- Overview of System Environment
- Identifying Bottlenecks.
- Optimizing Source, Target, mapping, Transformation, session.
Mapping Parameters and Variables
- Introduction to Mappng Variables and Parameters
- Creating Mapping Variables and Updating Variables
- Creating Parameter File and associating file to a Session
- System Variables
- Variables functions
Lab 26 - Override Mapping Variable with Parameter Files
Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable
Slowly Changing Dimensions Type 1, Type 2, Type 3
Incremental Loading
Lab 28– SCD 1, 2, 3
Reusable Workflow Tasks
- WorkLets
- Worklets Limitation
- Sessions
- Reusable Sessions
Lab 29 – Create Worklets using Tasks
Command Line Interface ( PMCMD)
- Overview of PMCMD and functions.
- Overview of PMREP and functions.
Lab 30 : PMCMD
PMREP
Informatica Migrations:
- Copying Objects
- Objects export and import (XML)
- Deployment groups
Workflows Scheduling:
- Using Informatica
- Unix crontab, third party tools.
Lab 30: Informatica Project- Case Study
- Sales Data mart.
- Loading Dimensions and Facts.
ETL Best Practices and methodologies
· Review the Industry best practices in ETL Development
· Review Real time project experiences of trainer
· Discuss what is learned techniques are useful in real world
· How to design effective ETL process
· Important considerations in designing ETL process
· Discuss real world prouction issues and support
· Discuss various roles in ETL world
· Busines Analyst, System Analyst
· System Architect
· Technical Architect, ETL Lead
· Stakeholders, Busines users
· Effective ways of using Data warehouse
· Review various BI Reporting methods
Q/A-Inteview perparation/Placements
§ Answer students questions
§ Tips for interview preparation
§ How we can assist in placement and future growth
§ Discuss other realted technologies like Business Intelligence(BI)
§ Advacing career options
softwarecabbges.com Training Courses
Business highlights
-
IT Professionals as Trainers
Learning a technology with a professional who is well expertise in that solve 60% of your needs.
-
Hands-on Training
We support any training should be more practical apart from theoretical classes. So, we always give you hands-on training.
-
Affordable Fees
We are dead cheap in fees. We are having options to make the payment in instalments as well if needed.
-
10000+ old students to believe
We satisfied 10000+ students from the day we started GangBoard
-
Counselling by Experts
We have every course material to understand which is prepared by our trainers and we will share with you after session completes.
-
Own Course Materials
We have every course material to understand which is prepared by our trainers and we will share with you after session completes.
Services offered
- Online Training
- Placements
Popular IT training modules
- Adobe Audition training
- Robotic Process Automation (RPA) training
- Microsoft IT Support Specialist training
- SAP Cloud For Customer training
- MS Dynamics CRM training
- Salesforce Integration training
- SAP FICO training
- UIPath training
- SAP Analytics Cloud training
- Ab Initio training
- Business Systems Analyst training
- Oracle Database 10g training
- SAS Clinicals training
- ITIL training
- Android training
- Adobe Photoshop training
- SAP ABAP HR training
- Oracle Database 9i training
- Sap BO Administration training
- Adobe Flash Animate training
- RF Optimization training
- PMI PMP training
- Oracle Apps DBA training
- Facets Business Analyst training
- RF Design training
- J2EE training
- Blockchain For FinTech training
- SEO training
- Wireless Network Security training
- Business Analyst Oil & Gas training
- Enterprise Blockchain Bootcamp For Solutions Engineers training
We value your time
Become a prime member and teach what you love in your free time, because can pick their desired time to teach their trainers
