sravaniravi Posted December 10, 2012 Report Share Posted December 10, 2012 [b]9startek is offering Informatica Training[/b][b].[/b] [b]Informatica Power Center 7.x/8.x/9.x[/b] Ø Introduction to ETL Logic Ø Overview of Staging Area Ø Need of ETL Logic Ø Difference between OLTP systems and OLAP systems Ø Construction of DWH/Datamarts using ETL logic Ø Introduction to Informatica Power Center Ø Overview of sub tools of the Informatica Power Center: [list] [*]Informatica Client [*]Informatica Server [*]Informatica Repository [*]Informatica Repository server [*]Internal Architecture of the server [/list] Ø Informatica client:[list] [*]Informatica designer [*]Workflow manager [*]Workflow monitor [*]Repository manager [*]Repository server administrative console [/list] Ø Informatica Designer:[list] [*]Source analyzer [*]Ware house designer/ target designer [*]Transformation developer [*]Mapplet designer [/list] · Mapping designer Ø Workflow manager:[list] [*]Workflow designer [*]Worklett designer [*]Task developer [/list] Ø Transformations:[list] [*]Reusable transformations [*]Non-reusable transformations [*]Active and Passive transformations [/list] [indent=1]1) Source qualifier[/indent] [indent=1]2) Expression[/indent] [indent=1]3) Aggregator[/indent] [indent=1]4) Rank[/indent] [indent=1]5) Filter[/indent] [indent=1]6) Router[/indent] [indent=1]7) Lookup[/indent] a) Connected Unconnected [indent=1]8) Stored Procedure and function[/indent] a) Connected Unconnected [indent=1]9) Update Strategy[/indent] [indent=1]10) Transaction control[/indent] [indent=1]11) Normalizor[/indent] [indent=1]12) Sequence generator[/indent] [indent=1]13) Union[/indent] [indent=1]14) Joiner ( Normal, Mate router, detail Outer, Full Outer)[/indent] 15) XML Source qualifier 16) Sorter 17) Mapplet input 18) Mapplet Output Ø Advanced Transformations: Java Transformation Sql Transformation HTTP transformation SAP R/3 Transformation Mapping designer: Ø Best practices when building mappings Ø Construction of simple mappings for dimension tables and fact tables Ø Dimension mappings:[list] [*]SCD type-1 [*]SCD type-2 [*]Flag current data [*]Effective data range [*]Version number mapping [/list] Development of the target tables from business user requirements [indent=1]Ø Source analyzer:[/indent][list] [*]Import source tables from different data bases or flat files [*]Create source tables in source analyzer itself. [/list] Ø Target designer:[list] [*]Import target tables from different data bases or flat files [*]Create target tables in target designer itself. [*]Reusable transformations in Transformation developer [*]Transformation logic development in Mapplet designer [*]Properties explanation of the transformations [*]Customised query generation in source qualifier [*]Pre and post sql [/list] Ø Differences between source qualifier and joiner transformation with practical explanation Ø Difference between filter and router transformations with practical explanation Ø Difference between expression and aggregator transformation with practical explanation Ø Overview of the workflow manager[list] [*]Reusable tasks development in task developer [*]Tasks logic development in worklett designer [*]Workflow development in workflow designer [/list] Ø Explanation of the different types of the memories Ø Overview of the load manager Ø Overview of the Data transformation manager Ø Overview of different types of tasks:[list] [*]Start task [*]Session task [*]Event wait [*]Event raise [*]Timer [*]Decision task [*]Control task [*]E-mail task [*]Command task [*]Scheduling a task [*]Mapping parameters and variables creation [*]Parameter file creation [*]Internal working function of the Informatica Power center [*]Parallel Pipeline partitioning [*]Creation and deletion of portioning points [/list] Ø Execution of the mappings:[list] [*]Normal execution [*]Debugging mode execution [/list] Ø Loading:[list] [*]Normal loading [*]Bulk loading [*]Constraint based loading [/list] Ø Lookup cache:[list] [*]Static [*]Dynamic [*]Recache from source [*]Persistent cache [*]Shared cache [/list] Ø Analysis of BRS Ø Development of RRS Sample project development Course provided by well experienced faculty. Please contact us at Phone: 214-501-8177 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.