Informatica course Beginner level by MP TechnoSolutions

Informatica contents
Index for DWH Concepts
• DWH Concepts
• What is BI?
• OLTP
• Data Warehousing
• Datamart
• What is Schema?
1. Star Schema
2. Snow- Flake Schema
3. Galaxy Schema
• Fact Table
• Granularity
• Dimension Table
• Data Modeling
• SCD Type-1
• SCD Type- 2
• SCD Type-3
• Staging Area
• Surrogate Key
Informatica Index
• ETL
• ETL Tools
• Informatica
1. Power Center
2. Power Mart
• Repository
• Mapping
• Structure of Designer
• Session
• Workflow Manager
Scenarios Covered
• One – to – One Mapping
• Customizing the Source Qualifier
• Concatenating First_Name, Last_Name and other Row Level Functions
• Implementing if – else statement using Expression Transformation
• How to filter the data using Filter Transformation
• Multiple Filter Conditions using Filter Transformation
• Need of Router of Transformation
• Joiner Transformation
• Transposing Columns into Rows using Normalizer Transformation
• Transposing Rows into Columns using Normalizer Transformation
• Combining Multiple Pipelines – using Union Transformation
• Usage of Lookup Transformation
• Unconnected Lookup
• Update Else Insert at Session Level
• Department wise Max Salary – using Aggregator Transformation
• Update Strategy Transformation
• Update Else Insert at Mapping level SCD Type – 1
• Sorter Transformation
• Fixed Width and Delimeter Flat File
• Populating Surrogate Key – using Sequence Generator
• Source First Record into First Target and Second Record into Second Target
• Multiple Flat Files into the target – Indirect File Type
• Populating Source Flat File Name in the target table
• Effective Date – SCD– Type 2
• Preventing source duplicate records using Lookup Transformation
• Cumulative Salary
• Variables – Incremental Logic (CDC)
• Control Table Logic
• Committing at Mapping Level
• Dynamic File Generation
• Generating sequence numbers without using Sequence Generator Transformation
• Assignment Task
• Event Wait – File Watch Mechanism
• Worklet
• Command Task
• Event Task
• Stored Procedure
• Difference between Informatica 7 and 8 versions
• Incremental Logic Using Parameter File
• Complex Mapping
• Handling Error Data
• Loading Unique Records into one table and duplicate records into another
• Preventing Duplicate Records in Flat Files
• Generating multiple records in target, based on source column
• updating the target table, if target doesn’t have Primary key
• Performance tuning in Informatica
• Unit Test Plan