Informatica - Live Training
| Class | Start Date | Status | Price |
|---|---|---|---|
| Informatica This class is Live in Dayton OH, and online everywhere else |
Aug 07 | Open | $2,500.00 |
Informatica - Online Training
| Class | Start Date | Status | Price |
|---|---|---|---|
| Informatica This class is Live in Dayton OH, and online everywhere else |
Aug 07 | Open | $2,500.00 |
Pre-recorded Classes for Sale!
| Training | Description | Number of Hours | Price | Buy now using Paypal |
|---|---|---|---|---|
| Informatica | Click Here for the Curriculum: | Unlimited - One Month | $500.00 |
TO RESERVE YOUR SPOT:
Call: 254-541-7124
E-mail: vijay@vxltraining.com
$500 payment immediately to reserve your spot and balance after the first day of class.
All of our credit card payments are processed by PayPal and are 100% secure.
You MUST EMAIL US with:
1) Name 2) Phone Number and 3) The Course you have signed up for, after you make your payment.
Please select the Option and Click on the Buy Now Button to pay for your class
Please select the Class and Option and Click on the Buy Now Button to pay for your class
Curriculum
Introduction to Data Warehousing
• What is Data Warehousing?
• Who needs Data Warehouse
• Operational Systems
• Decision Support Systems
OLTP Vs OLAP
• ODS (Operational Data Store)
• Data warehousing Life Cycle
• OLAP, ROLAP, MOLAP & HOLAP
Data Modeling
• Introduction to Data Modeling
• Entities and Attributes
• Use of Data Modeling in Data Warehousing
• Dimensions tables
• Hierarchies
• Fact tables
• Granularity for the Data Warehousing
• Star Schema
• Snowflake Schema
• Galaxy Schema
• Types of Facts
• Types of Dimensions
Part-I
Introduction to Informatica
ETL Architecture
1.Introduction to Informatica Client Tools
•RSAC
-Creating a Repository
-Connecting to the Rep Server
•Repository Manager
-Creating Folders, Users & Groups
-Privileges to the Users, User Groups & Folders
•Designer
-Connecting to Designer
-Components of Designer
-Creating DSN
-Importing Source & Exporting Target
-Types of Ports
-Developing simple Pass through mapping
-Tips to use Designer efficiently
•Workflow Manager
-Components of Workflow Manager
-Creating & Configuring Informatica Server
-Developing Session & Workflow
-Setting Session Properties
-Assigning Infa Server to Workflow
•Workflow Monitor
-Connecting to Infa Server
-Monitoring the Workflow & Session
-Session log & Workflow Log
2. Designer Transformations
• Naming Conventions
• Connected Vs Unconnected
• Active Vs Passive
• Source Qualifier
- As a filter
-Join Condition
-Optimizing SQL override
• Expression
• Filter
• Sequence Generator
• Rank
• Router
• Aggregator
• Joiner
• Stored Procedure (Connected & Unconnected)
• Lookup (Connected Vs Unconnected)
• Union
• XML
• Normalizer
• Custom
3. Implementing Type-I, Type-II, Type-III mappings
• Using Mapping Wizards
• Three different approaches
4. Workflow Manager
• Tasks
-Session
-Decision
-Command
-Email
-Event Raise & Event wait
-Link Conditions
• Developing Worklet
• Using Worklet in the Workflow
• Session task Properties
• Workflow Properties
• Scheduling workflow
5. Testing the Mapping
• Manually
• Using Performance Statistics
• Using Tracing Level
• Using Debugger
6. Working with Files
• Where & How to place Files
• Flat file as a Source and Target
• Dealing with Flat Files
7. Advanced Features
• Mapplet Implementation
• Mapping Parameters and Variables
• Reusable Transformations
• Global Definitions & Creating Shortcuts
• Session Parameters
• Bulk Loading
• Incremental Aggregation
• Target Load Plan
• Constraint Based Loading
• Deployment Process
• Sending Notification Messages
Class Location
38345 W 10 Mile Rd, Suite 380
Farmington Hills, MI 48335
Class Timings
Sat-Sun 9AM-5PM
Class Length: 2 Weeks
Office Location
38345 W 10 Mile Rd, Suite 110
Farmington Hills, MI 48335
FAQ
1) Tell me a little about the instructor?
Satish is certified in Informatica and have been teaching in Informatica for 3 years.
2) What is Informatica?
Informatica is an ETL tool for Data Extraction, Transformation and Loading into target databases
3) Will this course be enough for me to get a job in Informatica?
Yes, the course is taught in detail and it will be more than enough to get a job.
4) Is the instructor available via email or phone for support?
Yes, he is always available via email, but since he does work during the weekdays, he is availble in a limited capacity via phone.
5) Which Version of Informatica are you training on?
Informatica 7.1.3 & 8.10
6) Are there any prerequisites for this training?
Database Knowledge (SQL etc...), or just a real desire to learn and work hard.
7) What will I have accomplished by the end of this course?
You will have learned a ETL tool and if you do the work needed and practice as advised by the faculty, we will even guarantee a job to hard working candidates.
8) Can I pay the deposit or the full payment via Credit Card?
Yes, you can
- 9) What are your refund policies and anything else you feel I should know?
All tuition and fees paid by the applicant shall be refunded if the applicant is rejected by the School before enrollment. An application fee of not more than $25.00 may be retained by the school if the application is denied. All tuition and fees paid by the applicant shall be refunded if requested within 3 business days after signing a contract with the school. All refunds shall be returned within 30 days. Once the 3 business days have elapsed the following policies will apply: Withdrawal before start of 1st class = Full Refund, after start of 1st class = No Refund. Students who wish to file a complaint with The State of Michigan may do so at www.michiganps.net.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign are trademarks or registered trademarks of SAP AG.