Informatica Syllabus

- Different Definitions of data warehouse
- Difference between OPERATIONAL DS AND DWH
- Types of ETL
- Data Extraction
- Data Transformation
- Data Merging
- Data Loading
- Types of Data loading
- Data Aggregation
- ata warehouse Approaches
- Top down approach and Bottom up approach
- DW Life cycle
- DW-database design
- Star schema and Snow flake schema
- Facts and dimensions
- Granuality
- Types of Dimensions
- Types of fact table
- Types of Olap
- Informatica Power center architecture
- Power center components
- ETL Plan
- Power center Clients
- Designer
- Workflow manager
- Work Flow monitor
- Workflow manager
- Repository manager
- Power center repository
- Administrative tool
- Repository services
- Integration services
- Power center domain
- Application services
- Service manager
- Power center administration console
- Creating Repository Users and Groups .
- Connecting to the Repository.
- Creating a Group
- Assigning Privileges to a Group.
- Creating a User
- Creating a Folder
- Folder Permissions
- Creating Folders
Transformation Creation
- Creating Source Tables.
- Creating Target Definitions.
- Creating Target Tables
- Creating a Pass-Through Mapping
- Creating source definitions
- Creating a Mapping
- Connecting Transformations
- Using Transformations
- Creating a Mapping with Aggregate Values
- Active and passive transformations
- Creating an Aggregator Transformation
- Creating an Expression Transformation
- Creating a Lookup Transformation
- Connecting the Target
- Designer Tips.
- Using the Overview Window
- Arranging Transformations
- Creating the Session
- Creating the Workflow
- Creating a Mapping with Fact and Dimension Tables
- Creating a Filter Transformation
- Creating a Sequence Generator Transformation
- Creating a Stored Procedure Transformation
- Completing the Mapping
- Creating a Workflow
- Creating a Link Condition.
- Running the Workflow
- Using XML Files
- Creating the XML Source
- Importing the XML Source
- Editing the XML Definition
- Creating the Target
- Creating a Mapping with XML Sources and Targets
- Creating an Expression Transformation
- Creating Router Transformations
- Completing the Mapping
- Creating a Workflow
- How to monitor loads
- Use of Workflow monitor
- Connecting Transformations
- Creating Sessions and Workflows
- Configuring Database Connections in the Workflow Manager
- Creating a Reusable Session
- Creating a Workflow
- Running and Monitoring Workflows
- Opening the Workflow Monitor
- Running the Workflow
- Session
- Assignment task
- Link task
- Event raise task
- Event wait task
- Timer task
- Post session and Pre-session commands
- Session recovery
- Commit points
- Creation of Parameter file
- Mapping and session parameter
- Various optimization technique
- Pushdown optimization
- Incremental aggregation
Develop your ETL skills at Softlogic Systems, the leading Informatica Training Institute in Chennai with 100% Placement Assistance. Book a free demo class to know our infrastructure well.
Get access to the complete syllabus
Download NowOur Students Speak


Completing the Full Stack Development course at SLA has been an incredibly valuable experience for me. Under the guidance of my skilled trainer, Muthu Karthick, I gained a comprehensive understanding of the subject, covering everything from fundamental concepts to advanced topics. The syllabus was thoughtfully designed, ensuring a seamless learning process. The continuous support from the SLA Team was exceptional and greatly contributed to my growth. Thank you!


SLA's Python training was excellent! Learning Python was made simple by the course syllabus's structure. Rajesh Sir, my trainer, made us learn difficult subjects by effectively simplifying them and using practical examples. I definitely suggest SLA to anybody looking for an approachable and enjoyable Python learning experience. With SLA’s placement assistance and guidance, I’ve got placed in a reputable company for a competitive salary. thanks to SLA for a valuable time!


Throughout my Data Science training, I had an amazing experience at SLA. My trainer, RK Sir, made the classes easy to understand. Because of the carefully prepared course, I was able to fully understand every concept. With the help of real-time assignments, my abilities greatly improved. Through mock interviews, the placement team helped me gain confidence. I'm really grateful to Softlogic Systems and the team for aiding and mentoring me during my training.


SLA is the best place to develop your IT skills and expertise. With the guidance of my counsellor, I took the AWS course. My trainer, Pandian Sir, was very friendly and approachable. He clarified each and every one of my doubts. The course structure made my learning experience easy and comfortable. I was able to gain practical expertise with real-time projects. The placement team helped me acquire a job in a reputable company for an excellent salary. Thank you very much, SLA.


I'm an individual from a non-IT background with no technical skills. I joined Softlogic Institute to switch my career from non-IT to IT. SLA's Machine Learning syllabus is frequently updated and created in a simple manner, so that complex concepts like Deep Learning, NLP, and Generated Models can be learnt even by beginners. On top of that, instructors of Softlogic are highly intellectual and friendly to teach you all concepts and industry trends to help me advance my career.


I had the best Android development learning experience in the SLA. Their Android course syllabus is fully up-to-date and their trainers are also working in this specific field. Their guidance and syllabus covers introduction to advanced topics of android development which helped non-IT background people like me to learn easily. I learnt designing, testing, and publishing of Android, and got placed with a better package than i was expecting at my dream company.


I joined SLA to learn Java for advancements in my career. Softlogic's Java Course syllabus is well-crafted to suit learners of all levels from beginners to advanced. The trainers are also expertised and already working as IT professionals, thus they let me learn more above the syllabus like industry trends, and career opportunities.I learnt Programming easily and became well versed through their training approaches. I also had an experience to work on real-time projects.


I did my Power BI course in the Softlogic Institute and was completely satisfied with their guidance and syllabus. Their Syllabus covers key concepts such as Data Visualization, Data Modeling, Power Query, etc which are taught to me in a simple manner. I also did real-time projects and guided with more practical methods than just explaining the concepts. Their placement support is also really good and I got placed in one of the renowned MNC just after completing my course.


I highly recommend Softlogic Institute for Software Testing Training if you want to acquire comprehensive knowledge as well as career enhancement. My trainer, Mr.Isaki Kumar is highly knowledgeable and approachable, making sure every queries of us are addressed to offer a better learning experience. With that, we had a lot of practical sessions and real-time projects to ensure that we will meet the IT demands. Through which, I got placed in a top MNC as a software tester


SLA provided excellent AI training. The training material was thorough and covered all necessary subjects. The instructors were knowledgeable and supportive, which made learning enjoyable. My ability to apply the ideas effectively was aided by practical assignments. I feel ready for the information technology field. I now have more confidence in my abilities because of the practical experience and real-world assignments. SLA is the best place for high-quality IT training. Thank you!
