ONLINE INFORMATICA TRAINING COURSE
Apply For CourseDURATION : 45 DAYS
FACULTY : Mr. IRFAN(7+Years exp)
- Datawarehousing Concepts
- What is DWH?
- Characteristics of Datawarehouse
- Difference between OLTP and DWH
- Architecture of DWH
- Various BI tools
- Types of DWH
- Types of Dimensional Data Modeling
- Surrogate key
- Types of Dimension
- Data Mart
- Star Schema
- Snowflake Schema
- Slowly Changing Dimension(Type 1,2 and3)
- Confirmed Dimension
- Summary / Aggregations table
- Types of Transformations
- Source Qualifier Transformation
- Creating Simple Pass through Mapping
- Apply Various Filter Conditions
- Specify sorted ports
- Eliminate Duplicate Values
- Creating Custom SQL Query
- Joining two or more tables
- Filter Transformation
- Compare with Source Filter
- Types of Tracing Level
- Types of Flatfiles
- File Import Wizard
- Load data from Flat File to Database
- Load data from XML to Database
- Load data from Database to Flat File
- Sorter Transformation
- Types of Ports
- Multiple Sorting
- Null Treated Low option
- Joiner Transformation
- Joining two heterogenouse sources
- Types of Joins
- Sorted input option
- Rank Transformation
- Types of Ports
- Rank Index
- Rank and Dense rank
- Sequence Generator
- cycle option
- Usage of Reset
- Expression Transformation
- Use of Expression
- Usage of Variable Port
- IIF and Decode functions
- Power Center Transformation Language
- Conversion Functions
- Cleansing Functions
- Aggregator Transformation
- Informatica aggregate functions
- Router Transformation
- Types of Groups
- Group Conditions
- Union Transformation
- Types of Groups
- Normalizer Transformation
- Types of Normalizer
- Transpose Columns to Rows
- Default Output Ports
- Lookup Transformation
- Connected Vs Unconnected Lookups
- Unconnected Procedure
- Stored Procedure Transformation
- Create a Sample Procedure
- DBA Script
- Update Strategy Transformation
- Database opertations
- Data Driven
- Transaction control Transformation
- Dynamic File Generation
- SQL Transformation
ADVANCED INFORMATICA CONCEPTS
- Slowly Growing Dimension
- Slowly changing Dimension
- Type 1
- Type 2
- Type 3
- Transformation Developer
- Create a Reusable Transformation
- Promoting Transformations
- Mapplet Designer
- Create a reusable Mappings
- Mapping Parameters
- Design Parameter File
- Mapping Variables
- Set variables function
- Session variables
- Setting Connections
- File Repository Concepts
- Indirect loading
- Target Load Plan
- If we have multiple target which target to be loaded first.
- Types of Load
- Normal load
- Bulk Load
- Types of scheduling
- Time-based schedule
- Event -based schedule
- Mapping Migration Process
- Copy from Folder
- Import and Export
- Debugging Mappings
- How to debug and find errors in mapping
- Task Types
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Worklet
COURSES OFFERING
- 3DS MAX
- 3DS MAX & V-RAY
- ADOBE PHOTOSHOP
- ADOBE AFTER EFFECTS
- ADOBE PREMIERE PRO
- ADVANCE EXCEL
- ADVANCED JAVA
- MULTIMEDIA ADVANCED
- ANGULAR JS 1
- ANGULAR
- AUTOCAD 2D / 3D
- AWS
- BOOTSTRAP 5
- C LANGUAGE
- C++ LANGUAGE
- CODEIGNITER
- CORE JAVA
- DATA SCIENCE
- DATA STRUCTURES and ALGORITHMS in PYTHON
- DEVOPS
- DIGITAL MARKETING
- DTP
- DJANGO
- GRAPHIC DESIGNING
- HTML 4,5,6, CSS 2,3,4, JAVASCRIPT
- INFORMATICA
- JQUERY AJAX JSON
- LINUX ADMINISTRATION
- LINUX UNIX SHELLSCRIPTING
- MEAN ( FULLSTACK UI TECHNOLOGIES )
- MERN ( FULLSTACK UI TECHNOLOGIES )
- MS-OFFICE
- MS-OFFICE & ADVANCE EXCEL
- MS-OFFICE & ADVANCE EXCEL & VBA
- MS-PROJECT
- MULTIMEDIA ADVANCED
- ORACLE ADF
- ORACLE SQL PLSQL
- PHOTOSHOP
- PHP
- PRIMAVERA
- POWER BI
- PYTHON
- PYTHON + DJANGO
- REACT JS
- REVIT
- RUBY
- RUBY ON RAILS
- SALESFORCE CRM ADMINISTRATION & DEVELOPMENT
- SELENIUM
- SKETCHUP
- SPOKEN ENGLISH
- SPOKEN HINDI
- STAAD PRO
- Tally.ERP9 (GST)
- UI TECHNOLOGIES
- UI TECHNOLOGIES + ANGULAR
- UI TECHNOLOGIES + REACT JS
- MEAN ( FULLSTACK UI TECHNOLOGIES )
- MERN ( FULLSTACK UI TECHNOLOGIES )
- WEB / UI DESIGNING
- WEB / UI DESIGNING AND DEVELOPMENT
- WEB AND GRAPHIC DESIGNING
Solutions
