Binly Logo Binly Logo
  • Home
  • Courses
  • Listings
    • Training Institutes
    • Upcoming Classes
    • Trainers / Tutors
    • ClassRoom
    • Online / Remote
    • e-Learning
  • More
    • My Account
    • Add a Listing
    • Contact
Add a listing
Sign in or Register
Add a listing

Informatica course for freshers by AgAmA IT Solutions

0 reviews
  • Start Date
    May 31, 2025 - July 10, 2025
  • Duration
    60
  • Chat
  • Course Info
  • Book Demo
  • prev
  • next
  • Short List
  • Share
  • Report
  • prev
  • next
Course Category
  • Informatica
Request Call Back
Loading
Course Duration in Hours

60

Course Details

INFORMATICA ONLINE TRAINING COURSE CONTENT

Data Warehousing Concepts

Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
Slowly Changing Dimensions (SCD1, SCD2, SCD3)
Metadata
Dimentinal Table
Types Of Dim Tables
Fact Table
Types of Fact Tables
OLTP (OnLine Transaction Processing)
OLAP (Online Analysis And Processing)
OLTP Vs OLAP
Advantages of OLAP
Different Methodologies of DWH
PowerCenter Components and User Interface

Informatica PowerCenter Architecture
Informatica PowerCenter Client Tools
Start Using of the Designer, Workflow Manager and Workflow Monitor

Source Qualifier

Source Qualifier Transformation
SQL override in source qualifier transformation
Source qualifier transformation joins concept
Source qualifier transformation on Relational Databases
Source qualifier transformation on File systems
Source qualifier transformation filter concepts
Difference Between SQL Override, Other Options
Source Qualifier Transformation Performance Tunning
Pre SQL and Post in Source Qualifier Transformation

Expression, Filter, File Lists and Workflow Scheduler

Expression Editor
Filter Transformation
File Lists
Workflow Scheduler
Lab Load the Customer Staging Table and Real time issues

Joins, Features and Techniques I

Joiner Transformation
Shortcuts
Lab A Load Sales Transaction Staging Table
Lab B Features and Techniques I and Real time issues

Lookups and Reusable Transformations

Lookup Transformation
Reusable Transformations
Lab A Load Employee Staging Table
Lab B Load Date Staging Table and Real time issues

Debugger

Debugging Mappings
Lab Using the Debugger

Sequence Generator

Sequence Generator Transformation
Lab Load Date Dimension Table and Real time issues

Lookup Caching, More Features and Techniques

Lookup Caching
Lab A Load Promotions Dimension Table
Lab B Features and Techniques II
Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides

Router Transformation
Update Strategy Transformation
Expression Default Values
Source Qualifier Override
Target Override
Session Task Mapping Overrides
Lab Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging

Dynamic Lookup
Error Logging
Lab Load Customer Dimension Table

Unconnected Lookup, Parameters and Variables

Unconnected Lookup Transformation
System Variables
Mapping Parameters and Variables
Lab Load Sales Fact Table

Sorter, Aggregator and Self-Join

Sorter Transformation
Aggregator Transformation
Active and Passive Transformations
Data Concatenation
Self-Join
Lab Reload the Employee Staging Table and Real time issues

SCD type1 Hands-On LAB

SCD type2 Hands-On LAB

SCD type3 Hands-On LAB

Mapplets

Mapplets
Lab Load Product Daily Aggregate Table
Review and more Lab Activities and Real time issues

Workflow Variables and Tasks

Link Conditions
Workflow Variables
Assignment Task
Decision Task
Email Task
Lab Load Product Weekly Aggregate Table

More Tasks and Re-usability

Event Raise Task
Event Wait Task
Command Task
Reusable Tasks
Reusable Session Task
Reusable Session Configuration

Worklets and More Tasks

Worklets
Timer Task
Control Task

Gallery
Course Brochure
  • boSVp_AgAmAlogo.jpg View
Upcoming Class
  • July 12, 2025 5:34 pm - August 21, 2025 5:34 pm Add to Google Calendar Add to iCalendar
  • July 26, 2025 5:34 pm - September 4, 2025 5:34 pm Add to Google Calendar Add to iCalendar
  • August 9, 2025 5:34 pm - September 18, 2025 5:34 pm Add to Google Calendar Add to iCalendar
Request Fees
Contact by Phone
+919008207744
Mode of Learning
Classroom
Facilities
  • Course Materials
  • Interview Support
  • Course Fee Instalment
  • Flexible Class Timings
  • Mock Tests
  • Free Demo Class
  • Mock Interviews
  • Remote Training
  • Fast Track Classes
  • 1-on-1 Training
  • Corporate Training
  • Money-Back Guarantee
  • Certified Trainer
Who can Attend?

Any gruduate

Training Provided by
AgAmA IT Solutions
Location
  • AgAmA IT Solutions, Jaya Nagar (Bangalore),Bangalore,IN

    Get Directions
Request Demo Class
Loading

You May Also Be Interested In

Informatica Online for advanced learners by ROGERSOFT

Informatica training provided by Intellipaat helps you be a master in PowerCenter ETL tool, data integration…
  • Online
  • July 1, 2025 6:06 am - July 5, 2025 6:06 am
  • Get Fees
Kakkanad (Kochi)
0 – ₹10,000

Informatica course for advanced learners by IT Skill

Data Warehousing History, Advantages, Usage etc. Theoretical & Technical Architecture. Functions of…
  • Classroom
  • March 15, 2025 3:58 am - April 12, 2025 3:58 am
  • Get Fees
Thane
₹30,000 – ₹50,000

Informatica course Beginner level by MP TechnoSolutions

Informatica contents Index for DWH Concepts • DWH Concepts • What is…
  • Classroom
  • May 9, 2025 12:20 am - July 8, 2025 12:20 am
  • Get Fees
Marathahalli (Bangalore)
₹10,000 - 20,000
  • About
  • Terms
  • Refund
  • Privacy
  • Contact
  • Add Listing

© BINLY LEARN

Cart

  • Facebook
  • Twitter
  • WhatsApp
  • Telegram
  • LinkedIn
  • Tumblr
  • VKontakte
  • Mail
  • Copy link