Why This Course
Informatica : A Leader in Entreprise ETL – Forrester Research
Informatica professionals earn upto $130,000 per year – Indeed.com salary data
GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.
More than 350+ Satisfied learners. Know about their learning experience
Instructor Live Online Sessions – Provides real-time interaction with the instructor and learners as per their respective time zones.
Support – Our expert trainers are willing to support you even after completion of your training. This will make you more confident to work for an organization
Real-time Case Studies – Based on an in-depth investigation of a professional, group or event to explore the causes of underlying principles, which are helpful to master you in your course
Certification – Learner, who completed their training with eTrainingsIndia will get a softcopy of training certificate stating that particular learner trained with eTrainingsIndia.
Create an integration service
Create users and users groups and assign privileges
Working with logs
Explanation on data movement mode
ASCII and Unicode
Ware house designer/ target designer
Active and Passive transformations
c)Difference between Dynamic Lookup, Static Lookup, Persistence Lookup And Re-cache from the source
8)Stored Procedure and function
14)Joiner ( Normal, Master outer, detail Outer, Full Outer)
15)XML Source qualifier
Advanced Transformations: Java Transformation
Sql Transformation HTTP transformation SAP R/3 Transformation Data Masking
Data Unstructured Mapping designer:
Best practices when building mappings
Construction of complex mappings for dimension tables and fact tables
Flag current data
Effective data range
Version number mapping
Design type-1, type-2, and type-3 dimensions for various requirements within a single mapping (Hybrid Dimension-HSCD).
Working with rapidly changing dimensions (Monster Dimensions)
Construction of the complex mappings for Data warehousing
Creation of the cubes
Analysis of Business user requirements
Combined type-1,type-2 and type-3 in a single mapping
Working with SCD wizards
Working with Rapidly Changing dimensions (RCD).
Development of the target tables based on business user requirements
Import source tables from different data bases or flat files
Working with XML files
Working with COBOL files
Create new source tables in the sources analyzer
Define the relationships
Create source tables in source analyzer itself.
Import target tables from different data bases or flat files
Create target tables in target designer itself.
Reusable transformations in Transformation developer
Transformation logic development in Mapplet designer
Properties explanation of the transformations
Customized query generation in source qualifier
Pre and post sql
Differences between source qualifier and joiner transformation with practical explanation
Difference between filter and router transformations with practical explanation
Difference between expression and aggregator transformation with practical explanation
Overview of the workflow manager
Reusable tasks development in task developer
Tasks logic development in worklett designer
Workflow development in workflow designer
Design sequential and concurrent batch workflow
Explanation of the different types of the memories
Overview of the load manager
Overview of the Data transformation manager
Overview of different types of tasks:
Mapping parameters and variables creation
Parameter file creation
Internal working function of the Informatica Power center
Parallel Pipeline partitioning
Creation and deletion of partitioning points
Execution of the mappings:
Debugging mode execution
Constraint based loading
Re-cache from source
Introduction to Load Manager (LM)
Overview on DTM (Data Transformation Manger)
Working with Parallel pipeline partitioning mechanism: Source level, transformations level and target level.
Types of threads:
Analysis of BRS
Development of RRS
Sample project development:
Star Schema Design with Dimension Tables and fact table.
Benefits of Star Schema
Overview on foreign keys and candidate key
Design a complex workflow for sample project
Frequently Asked Questions
♦ Can I Attend a Demo Session Before Enrolment ?
We have limited participants or only one participant in a live session to maintain the quality standards. Se we provide demonstration session before enrolment. However, without attending demonstration learner couldn’t able to clear his technical doubts about his desired technology. So we always recommend a learner to attend a demonstration with the person who will deliver the classes.
♦ Who is the instructor at eTrainingsIndia ?
All the instructors at eTrainingsIndia are experts from the industry with minimum 9-12 years of relevant IT experience. They are subject matter experts for providing an awesome learning experience.
♦ What if I miss a class ?
You will never lose any session. You can choose either of the two options:
- Ask for a recorded session of the class from your instructor.
- You can attend the missed session, in any other live session by the same instructor.
- Prior update or intimation is needed if you are not attending the session
♦ Will I Get Placement Assistance ?
eTrainingsIndia is committed to giving you an adorable learning experience through our live online training and expert instructors. Through our training we will enable you to convert opportunities into job offers by presenting your skills at your interview. We can assist you in resume building. Please understand that we are not into placement services.
♦ What If I have more queries ?
Feel free to reach us at +91 9010769088 or mail us at firstname.lastname@example.org