About Course
Informatica Course Description
Informatica Online Training, Learn Informatica - Expertise in Informatica ETL & Master in Power center ETL tool, data integration and data warehousing concepts, Informatica course in Hyderabad, Banglore, India, USA, CANADA, UK, AUSTRALIA..etc: attend Free Demo, life time access | 24*7 Support | Life Time Video Access
Frequently Asked Questions
- You will never miss a class at Suntrainings! You can choose either of the two options:
- 1. You can go through the recorded session of the missed class and the class presentation that are available for online viewing through the LMS.
- 2. You can attend the missed session, in any other live batch. Please note, access to the course material will be available for lifetime once you have enrolled into the course.
- Sun Trainings is committed to provide you an awesome learning experience through world-class content and best-in-class instructors.
- We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
- We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
- All instructors at Sun Trainings are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Sun Trainings to provide impeccable learning experience to all our global users.
- You can Call us at +91 9642434362 OR Email us at contact@suntrainings.com. We shall be glad to assist you.
Informatica Course Curriculum
- 1. SQL
- 2. PL /SQL Basics
- 3. Toad and SQL Developer Tools
- 4. Data Warehouse
- 5. Informatica Power Center 9.6
- 6. Unit Testing
- 7. Deployment activities
- 8. Unix Basics and Shell scripting
- 9. Real-time Projects
- Introduction
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Retrieval Language (DRL)
- Transaction Control Language (TCL)
- Data Control Language (DCL)
- Data Types
- Conditional Selections and Operations
- Where
- Order by
- Operators
- Arithmetic operators
- Comparison operators
- Logical operators
- Arithmetic operators
- +, -, *, /
- Comparison operators
- =, !=, >, <, >=, <=, <>
- Between not between
- in, not in
- null, not null
- like
- Logical operators
- And
- Or
- Not
- Single row functions
- a. Numeric functions
- b. String functions
- c. Date functions
- d. Miscellaneous functions
- e. Conversion functions
- Group functions
- a. Sum
- b. Avg
- c. Max
- d. Min
- e. Count
- Domain integrity constraints
- a. Not null
- b. Check
- Entity integrity constraints
- a. Unique
- b. Primary key
- Referential integrity constraints
- a. Foreign key
- USING MERGE
- SUBQUERY
- DISTINCT
- GROUP BY AND HAVING
- SET OPERATORS
- Difference between ROWID and ROWNUM
- Accessing External Table Data
- Difference between External and normal tables.
- Equi join
- Non-equi join
- Self-join
- Natural join
- Cross join
- Simple view
- Complex view
- Inline View
- Range partitions
- List partitions
- Single row sub queries
- Multi row sub queries
- Multiple sub queries
- Correlated sub queries
- Unique index
- Non-unique index
- Btree index
- Bitmap index
- Initial Analysis
- Run Explain Plan
- Create Index
- Table analysis
- Hints
- Partitions
- Variables
- Constants
- Records
- Conditional Statements
- Procedures
- Functions
- Parameters-Procedure, Function
- Exception Handling
- Business Intelligence
- Data Warehouse
- What is a DataMart
- What is the difference between a data warehouse and a Data Mart
- OLTP
- ODS (Operational Data Sources)
- What is Staging area and why we need it in DWH
- QUERY TUNING
- Initial Analysis
- Run Explain Plan
- Create Index
- Table analysis
- Hints
- Partitions
- Schemas
- Star schema
- Snowflake schema
- Dimension and Fact Types of Dimensions
- Slowly Changing Dimension( SCD)
- SCD-Type1– Current Data
- SCD-Type2 – Historical Data
- SCD-Type3 – Partial History
- Confirm Dimension
- Junk Dimension
- De Generated Dimension
- Types of facts
- Additive
- Semi-Additive
- Non-Additive
- Factless Fact Table
- Granularity
- Data cleansing
- Surrogate key
- Difference between a primary key and a surrogate key
- Top Down approach
- Bottom Top approach
- Power Center
- Power Mart
- Designer
- Workflow Manager
- Repository Manager
- Integration Services
- Repository Services
- Integration Service Process (ISP)
- Data Transformation Manager (DTM) Process
- Session
- Workflow
- Source Definition
- Target Definition
- Types of facts
- Additive
- Semi-Additive
- Non-Additive
- Factless Fact Table
- Granularity
- Data cleansing
- Surrogate key
- Difference between a primary key and a surrogate key
- Top Down approach
- Bottom Top approach
- Informatica Installation
- Informatica Transformations
- Source Qualifier
- Filter
- Expression
- Router
- • Session Level UPDATE else INSERT
- • Mapping Level UPDATE else INSERT
- Update Strategy Transformation
- • Mapping level
- • Session level
- Joiner Transformation
- Differences between dynamic lookup and static lookup
- Difference between mapping level and session level variables
- • Session level variables
- • Mapping level variables
- Sequence Generator
- Normalizer Transformation
- Incremental logic or Delta or CDC
- Using parameter file
- Using oracle Control tables
- Transaction Control Transformation
- Lookup
- a. Connected
- b. Unconnected
- Lookup Caches
- Persistent cache
- • Re-cache from lookup source
- • Static cache
- • Dynamic cache
- • Shared cache
- Aggregator
- Analytical Functions
- • First row Function
- • Last row Function
- Flat Files
- • Delimiter
- • Fixed Width
- List Files
- SCD Type-I Update else Insert
- SCD Type-II
- • Effective-Date Approach
- • Flag Approach
- • Version Approach
- SCD Type-III
- Constraint Base Load in Session Level
- Parameter Files
- Rank Transformation
- Stored ProcedureTransformation
- Sorter Transformation
- Input Transformation
- Output Transformation
- Union Transformation
- SQL Transformation
- Java Transformation Overview
- XML Generator
- XML Parser
- Mapplet Input Transformation
- Mapplet output Transformation
- Some other IMP transformations
- • Performance tuning in Informatica
- • Informatica Session Log shows busy percentage
- • Target Update Override
- • Overriding the WHERE Clause
- • Difference between 7.x and 8.x and 9.X
- • Power Center 9.X Architecture.
- Miscellaneous
- Shortcuts
- Recovery
- Session Log
- Debugger
- Worklets
- Active & Passive
- Standard & Reusable
- Scheduling
- Email Task
- Decision Task
- Concurrent Workflows
- Complex Mapping
- Error Handling
- Mapplets
- Code Pages
- Meta Data
- Versioning
- Third Party Tools
- Putty
- • Edit Plus
- • FTP (File Transfer Protocol) – File Zilla
- UNIX:: Introduction to the UNIX Operating System
- • What is UNIX?
- • Files and processes
- • The Directory Structure
- • Starting an UNIX terminal
- • Listing files and directories
- • Making Directories
- • Changing to a different Directory
- • Copying Files
- • Moving Files
- • Removing Files and directories
- • Displaying the contents of a file on the screen
- • Searching the contents of a file
- • Pipes
- • Other Useful UNIX commands
- Basics of the VI editor
- • Shell script to upload files in Informatica server
- • Shell script to transfer files from Informatica server to remote server
- • Shell script to load Data
- • Shell script to create indicator file
- • Shell script to create indicator file
- • Some other useful scripts.
- Real time standard unit test cases will be explained.
- introduction about Deployment
- Deployment activities on different DB environments.
- Introduction about Database Environments
- TEST
- DEV
- QA
- UAT
- PROD
- Migration Projects
- New Development or Start up project
- Production Support /Enhancement Project
- 24/ 7 Project
- 2 Real time Projects (Sales & Pharma) will be explain and will share the project documents.
Trainer Information
- Trainer has 15+ years of experience in IT industry.
