 |
|
|
|
|
|
|
Classifieds: Education / Training | | Informatica Training and Placement | | Posted By: tek star at: 1, Feb 2013 11:31:48 PM IST | 9startek is offering Informatica Training.
Informatica Power Center 7.x/8.x/9.x
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:
• Informatica Client
• Informatica Server
• Informatica Repository
• Informatica Repository server
• Internal Architecture of the server
Informatica client:
• Informatica designer
• Workflow manager
• Workflow monitor
• Repository manager
• Repository server administrative console
Informatica Designer:
• Source analyzer
• Ware house designer/ target designer
• Transformation developer
• Mapplet designer
• Mapping designer
Workflow manager:
• Workflow designer
• Worklett designer
• Task developer
Transformations:
• Reusable transformations
• Non-reusable transformations
• Active and Passive transformations
1) Source qualifier
2) Expression
3) Aggregator
4) Rank
5) Filter
6) Router
7) Lookup
a) Connected
b) Unconnected
8) Stored Procedure and function
a) Connected
b) Unconnected
9) Update Strategy
10) Transaction control
11) Normalizor
12) Sequence generator
13) Union
14) Joiner ( Normal, Mate router, detail Outer, Full Outer)
15) XML Source qualifier
16) Sorter
17) Mapplet input
18) Mapplet Output
Advanced Transformations:
Java Transformation
Sql Transformation
HTTP transformation
SAP R/3 Transformations
Mapping designer:
Best practices when building mappings
Construction of simple mappings for dimension tables and fact tables
Dimension mappings:
• SCD type-1
• SCD type-2
• Flag current data
• Effective data range
• Version number mapping
• SCD type-3
• Construction of the complex mappings for Data warehousing
• Creation of the cubes
• Analysis of Business user requirements
Development of the target tables from business user requirements
Source analyzer:
• Import source tables from different data bases or flat files
• Create source tables in source analyzer itself.
• Target designer:
• 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
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
• Reusable tasks development in task developer
• Tasks logic development in worklett designer
• Workflow development in workflow designer
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:
• 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
Execution of the mappings:
• Normal execution
• Debugging mode execution
Loading:
• Normal loading
• Bulk loading
• Constraint based loading
Lookup cache:
• Static
• Dynamic
• Recache from source
• Persistent cache
• Shared cache
Analysis of BRS
Development of RRS
Sample project development
Course provided by well experienced faculty.
Please contact us at
Phone: 214-501-8177
Email:9startek@gmail.com
Regards
Sravani
9startek,
1333 Corporate Drive, Suite #108
Irving, TX 75038
(Direct): 214-501-8177
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
