Curriculum:
- Data Warehouse
- Data Mart
- OLAP VS OLTP
- Data Warehouse Architecture (Basic
- Data Warehouse Architecture (with a Staging Area)
- Dimensional Modeling
- Star Schema
- Star Schema
- Dimension
- Fact
- Slowly Changing Dimension(Type 1,2 and3)
- HSCD or ASCD
- Confirmed Dimension, Junk, De-Generate
- Transaction Grain, Periodic, Accumalated, Factless Fact Table.
- Summary / Aggregations ta
- Change Data capture
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Informatica Architecture.
- Source Analyzer
- Target Designer
- Transformations
- Mappings
- Mapplets
- Sessions
- Tasks
- Working with relational Sources
- Working with Flat Files
- Working with Relational Targets
- Working with Flat file Targets
- Expression Transformation
- Lookup Transformation
- Sequence Generator Transformation
- Filter Transformation
- Joiner Transformation
- Sorter Transformation
- Procedural Transformation
- Router Transformation
- Aggregator Transformation
- Update Strategy Transformation
- Union Transformation
- Rank Transformation
- Transaction Control Transformation
- Normalizer Transformation
- Source Qualifier Transformation
- Stored Procedure Transformation
- XML Source Qualifier Transformation
- Debugging Mappings
- Numeric functions
- String Functions
- Date Functions
- Conversion Functions
- Cleansing Functions
- Aggregate Functions
- User Defined Functions
- Unconnected lookup Transformation
- Unconnected Stored Procedure to Create and Drop Index
- Mapplet and Types of Mapplets
- Defining Reusable Transformations
- User Defined Functions
- Tasks And Types of Tasks
- Worklet and Types of Worklets
- Scheduling Work flow
- Constraint Based Load Ordering
- Target Load Plan
- Types of Batch Processing
- Link conditions
- Mapping Parameters
- Mapping Variables
- Defining Session Parameters
- Session Recovery
- Difference Between Normal and Bulk Loading
- PMCMD Utility
- PMREP Utility
- Incremental Aggregation
- Static LookUp Cache
- Dynamic LookUp Cache
- Persistence lookup Cache
- Shared LookUp Cache
- Sorter and Rank Cache
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Decision
- Assignment
- Control
- Worklet
- Project 1
- Project 2
Fee:
Self Paced Learning
Get the recorded session and study Material. Learn in your speed
30000Online Virtual Class Room
Enroll in any above batch and attend live class at scheduled time
30000Offline Class Room
Visit our centre and enrol for the course, The course Fee will vary as per the Metro/ Non Metro or locality.
30000Upcoming Batches:
FAQ:
1.Where we can use Informatica ETL concept?
We can use this concept any where in any company whether it is a small company or big company . but mostly it is used for collection of big data .
2.Any Prerequisite to learn Informatica ETL?
There is no prerequisite to learn Informatica ETL. If you are familiar with computer or have basic concept of any other programming language it would be an added advantage to you. By the way, we will start this training from scratch.
3.Recommend Audience for Informatica ETL course:
Anyone who is interested to learn Informatica ETL can join this course like students and working professionals.
4.In case of my absence, how can I manage my class?
You will get access of LMS (Learning management System), if you missed your class you can refer the recorded session in your LMS. If you have any doubt you can ask in your next class whenever you will join.
5.Who is the Instructor?
Our instructors are industry experts having more than 10 years of corporate experience. Since they have rich experience in their domain they will train as per the industry standards.
6.Will you help us in Job placement?
We have tied up with more than 100+ companies in corporate industry. We will schedule your interview after successful completion of our course.
7.Will you help us in resume creation?
Yes, we will help you in creating your resume so that it can shortlist easily for interview.
8.Will you help us to get the software?
Yes, we will help you with Trial version of software.
9.How long can I access my (LMS) learning management System?
Once you will enroll for the course, you can access the LMS for life long.
10.How can I get the certification?
Once you will complete your course, you will appear for an online test. Basis on your score we will issue the certificate.
11.What is Self-paced course?
If you will enroll for self-paced course you can access the pre recorded sessions and you can do self-learning. You can complete your course as per your availability.
12.What is Instructor driven course?
This is online virtual class room training, since this is live class, you can clear your doubts in the class.
13.What if I have more queries or concerns?
You can write an email at info@wifilearning.com or you can contact us at our Office numbers at 91-9999468661
Recommended Courses:
Recommended courses
AWS Solutions Architect Certification Course
Advanced Python
