Informatica 9 Online Training By Real Time Professional @ A2Z Online T

[sarajohn]

[b] Informatica Online Training Course Content:[/b]

[url="http://www.a2zonlinetraining.com/datawarehousing-online-training/informatica-online-training.php"]Informatica 9 Online Training[/url]

[indent=1][b]Data Warehousing Concepts[/b][/indent]

[indent=1]1. Data Warehouse[/indent]
[indent=1]2. Data Mart[/indent]
[indent=1]3. OLAP VS OLTP[/indent]
[indent=1]4. Data Warehouse Architecture (Basic)[/indent]
[indent=1]5. Data Warehouse Architecture (with a Staging Area)[/indent]
[indent=1]6. Dimensional Modeling[/indent]
[indent=1]7. Star Schema[/indent]
[indent=1]8. Snowflake Schema[/indent]
[indent=1]9. Dimension[/indent]
[indent=1]10. Fact[/indent]
[indent=1]11. Slowly Changing Dimension[/indent]
[indent=1]12. Hierarchy[/indent]
[indent=1]13. Confirmed Dimension[/indent]
[indent=1]14. Fact less Fact[/indent]
[indent=1]15. Summary / Aggregations table[/indent]
[indent=1]16. Change Data capture[/indent]


[b] E T L Informatica Power Center 9[/b]




[indent=1]1. Power Center Components[/indent]
[indent=1]a) Designer[/indent]
[indent=1] B) Repository Manager[/indent]
[indent=1]c) Workflow Manager[/indent]
[indent=1]d) Workflow Monitor[/indent]

[indent=1][b]2. Informatica Concepts and Overview[/b][/indent]
[indent=1]a) Informatica Architecture. [/indent]
[indent=1] B) Source Qualifier[/indent]
[indent=1]c) Target Designer[/indent]
[indent=1]d) Transformations[/indent]
[indent=1]e) Mappings[/indent]
[indent=1]f) Mapplets[/indent]
[indent=1]g) Sessions[/indent]
[indent=1]h) Tasks[/indent]

[indent=1][b]3. Sources[/b][/indent]
[indent=1]a) Working with relational Sources[/indent]
[indent=1] B) Working with Flat Files[/indent]

[indent=1][b]4. Targets[/b][/indent]
[indent=1]a) Working with Relational Targets[/indent]
[indent=1] B) Working with Flat file Targets[/indent]

[indent=1][b]5. Transformations[/b][/indent]
[indent=1]a) Expression Transformation[/indent]
[indent=1] B) Lookup Transformation[/indent]
[indent=1]c) Sequence Generator Transformation[/indent]
[indent=1]d) Filter Transformation[/indent]
[indent=1]e) Joiner Transformation[/indent]
[indent=1]f) Sorter Transformation[/indent]
[indent=1]g) Procedural Transformation[/indent]
[indent=1]h) Router Transformation[/indent]
[indent=1]i) Aggregator Transformation[/indent]
[indent=1]j) Update Strategy Transformation[/indent]
[indent=1]k) Union Transformation[/indent]
[indent=1]L) Rank Transformation[/indent]
[indent=1]M) Transaction Control Transformation[/indent]
[indent=1]N) Normalizer Transformation[/indent]
[indent=1]O) Source Qualifier Transformation[/indent]
[indent=1]P) Stored Procedure Transformation[/indent]
[indent=1]Q) XML Source Qualifier Transformation[/indent]
[indent=1]R) Debugging Mappings[/indent]

[indent=1][b]6. Power Center Transformation Language[/b][/indent]
[indent=1]a) Numeric functions[/indent]
[indent=1] B) String Functions[/indent]
[indent=1]c) Date Functions[/indent]
[indent=1]d) Conversion Functions[/indent]
[indent=1]e) Cleansing Functions[/indent]
[indent=1]f) Aggregate Functions[/indent]
[indent=1]g) User Defined Functions[/indent]

[indent=1][b]7. ADVANCED INFORMATICA CONCEPTS[/b][/indent]
[indent=1]a). Unconnected lookup Transformation[/indent]
[indent=1] B). Unconnected Stored Procedure to Create and Drop Index[/indent]
[indent=1]c). Mapplet and Types of Mapplets[/indent]
[indent=1]d). Defining Reusable Transformations.[/indent]
[indent=1]e). User Defined Functions.[/indent]
[indent=1]f). Tasks And Types of Tasks.[/indent]
[indent=1]g). Worklet and Types of Worklets.[/indent]
[indent=1]h). Scheduling Work flow[/indent]
[indent=1]i). Constraint Based Load Ordering.[/indent]
[indent=1]j). Target Load Plan[/indent]
[indent=1]k). Types of Batch Processing[/indent]
[indent=1]l). Link conditions[/indent]
[indent=1]m). Mapping Parameters[/indent]
[indent=1]n). Mapping Variables[/indent]
[indent=1]o). Defining Session Parameters[/indent]
[indent=1]p). Session Recovery[/indent]
[indent=1]q). Difference Between Normal and Bulk Loading.[/indent]
[indent=1]r). Push Down Optimization.[/indent]
[indent=1]s). PMCMD Utility[/indent]
[indent=1]t). PMREP Utility[/indent]
[indent=1]u). Incremental Aggregation[/indent]
[indent=1]v). TYPES Of LookUp Caches.[/indent]
[indent=1] a) Static LookUp Cache[/indent]
[indent=1] B) Dynamic LookUp Cache[/indent]
[indent=1] c) Perisistance lookup Cache[/indent]
[indent=1] d) Shared LookUp Cache[/indent]
[indent=1]w). Sorter and Rank Cache.[/indent]
[indent=1]x). ETL UNIT Testing (8 test Cases)[/indent]
[indent=1]y). ETL PERFORMANCE TESTING (3 test cases)[/indent]
[indent=1]z). ETL Performance Optimization techniques[/indent]
[indent=1]za). Task Implementations.[/indent]
[indent=1]1 Session[/indent]
[indent=1]2 Command[/indent]
[indent=1]3 EMAIL[/indent]
[indent=1]4 Timer[/indent]
[indent=1]5 Event Wait[/indent]
[indent=1]6 Event Raise[/indent]
[indent=1]7 Decision[/indent]
[indent=1]8 Assignment[/indent]
[indent=1]9 Control[/indent]
[indent=1]10 Worklet[/indent]
[url="http://www.a2zonlinetraining.com/datawarehousing-online-training/informatica-online-training.php"]Informatica Online Training[/url]

[ManOnFire]