Jump to content

Informatica Training And Placement - H1 Visa Sponsorship


sravaniravi

Recommended Posts

[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
B) Unconnected
[indent=1]8) Stored Procedure and function[/indent]
a) Connected
B) 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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...