Informatica Training And Placement - H1 Visa Sponsorship

[sravaniravi]

[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