Informatica Demo On 18Th Jan At 9 Am(Ist)

[training4u]

[color=#FF0000][font=helvetica, arial, sans-serif][size=6]Email : [email protected][/size][/font][/color]
[color=#FF0000][font=helvetica, arial, sans-serif][size=6]Contact No : +91 9036298699[/size][/font][/color]

[color=#0000ff][size=6]Informatica Demo[/size][/color] [color=#0000FF][font=helvetica, arial, sans-serif][font=arial, helvetica, sans-serif][size=6] on 18th Jan at 9 AM(IST) || 17[/size][size=6]th Jan at 10.30 PM(EST).[/size][/font][/font][/color]




[b][u]MODULE – 1 [/u][/b][u] [b]Data Warehousing Concepts[/b][/u]

[b]What is a Data Warehouse?[/b]
[indent=1]Subject Oriented.[/indent]
[indent=1]Integrated.[/indent]
[indent=1]Nonvolatile .[/indent]
[indent=1]Time Variant.[/indent]
[indent=1]Differences between OLTP and Data Warehousing Environments.[/indent]

[b]Data Warehouse Architectures [/b].

[indent=1]Data Warehouse Architecture (Basic)[/indent]
[indent=1]Data Warehouse Architecture (with a Staging Area).[/indent]
[indent=1]Data Warehouse Architecture (with a Staging Area and Data Marts) [/indent]

[b]Logical and Physical Design in Data Warehouses [/b]

[b]Logical Design in Data Warehouses[/b]
.

[b]Data Warehousing Schemas[/b]
[indent=1]Star Schemas.[/indent]
[indent=1]Snowflake Schemas.[/indent]

[b]Data Warehousing Objects[/b].
[indent=1]Fact Tables.[/indent]
[indent=1]Creating a New Fact Table[/indent]
[indent=1]Dimension Tables[/indent]
[indent=1]Unique Identifiers.[/indent]
[indent=1]Relationships .[/indent]
[indent=1]Surrogate key[/indent]
[indent=1]Slowly changing Dimensions[/indent]

[b]MODULE – 2 [u]Introduction to Erwin Tool[/u][/b]


[b]Creating a Logical Design [/b][b]Putting ERwin To Work![/b]
[indent=1]Working With Data Models[/indent]
[indent=1]What Is An Entity?[/indent]
[indent=1]What Is An Attribute?[/indent]
[indent=1]What Is A Relationship?[/indent]
[indent=1]What Is A Foreign Key?[/indent]
[indent=1]Splitting A Logical/Physical Data Model[/indent]
[indent=1]Derive A New Model[/indent]
[indent=1]Forward Engineering[/indent]


[b]Physical Design in Data Warehouses[/b]

[b]Moving from Logical to Physical Design[/b].
[b]Physical Design [/b].
[indent=1]Physical Design Structures .[/indent]
[indent=1]Tablespaces .[/indent]
[indent=1]Tables and Partitioned Tables.[/indent]
[indent=1]Indexes and Partitioned Indexes .[/indent]
[indent=1]Materialized Views.[/indent]

[b]Building a Data Warehouse using Physical Desgin.[/b]
[indent=1]Schema Generation[/indent]
[indent=1]Creating a script[/indent]
[indent=1]Rolling the ddl into the Oracle Server.[/indent]
[b][u]MODULE – 3 INFORMATICA[/u][/b]

Understanding Domains
[indent=1]Nodes [/indent]
[indent=1]Gateway Nodes[/indent]
[indent=1]Worker Nodes[/indent]
[indent=1]Service Manager[/indent]
[indent=1]Application Services[/indent]
[indent=1]Integration Service[/indent]
[indent=1]Repository Service[/indent]

Managing Users and User Accounts
[indent=1]Users and User Accounts[/indent]
[indent=1]Domain Administrator[/indent]
[indent=1]Root Administrators and Domain Users[/indent]
[indent=1]Managing Users[/indent]
[indent=1]Managing Permissions and Privileges[/indent]
[indent=1]Managing Permissions[/indent]
[indent=1]Managing User Privileges[/indent]
[indent=1]Managing Your Account[/indent]

Creating and Configuring the Repository Service
[indent=1]Creating a Database for the Repository[/indent]
[indent=1]Creating the Repository Service[/indent]
[indent=1]Creating a Repository Service[/indent]
[indent=1]Database Connect Strings[/indent]
[indent=1]Configuring Repository Service Properties[/indent]
[indent=1]Node Assignments[/indent]
[indent=1]General Properties[/indent]
[indent=1]Database Properties[/indent]
[indent=1]Custom Properties[/indent]
[indent=1]Configuring Repository Service Process Properties[/indent]
Managing the Repository
[indent=1]Enabling and Disabling the Repository Service[/indent]
[indent=1]Enabling and Disabling a Repository Service[/indent]
[indent=1]Running in Exclusive Mode[/indent]
[indent=1]Creating and Deleting Repository Content[/indent]
[indent=1]Creating Repository Content[/indent]
[indent=1]Deleting Repository Content[/indent]
[indent=1]Setting Up LDAP Authentication for Repositories[/indent]
[indent=1]Configuring the LDAP Authentication Module for the Domain[/indent]
[indent=1]Registering an LDAP Security Module with a Repository[/indent]
[indent=1]Unregistering an LDAP Security Module .[/indent]

Creating and Configuring the Integration Service
[indent=1]Creating an Integration Service[/indent]
[indent=1]Enabling and Disabling the Integration Service[/indent]
[indent=1]Running in Normal and Safe Mode[/indent]
[indent=1]Running the Integration Service in Safe Mode[/indent]
[indent=1]Configuring the Associated Repository[/indent]
[indent=1]Configuring the Integration Service Processes .[/indent]

[center][b][u]Working with Transformations[/u][/b][/center]

[indent=1]Creating a Transformation[/indent]
[indent=1]Configuring Transformations[/indent]
[indent=1]Working with Ports[/indent]
[indent=1]Working with Expressions[/indent]
[indent=1]Using Local Variables[/indent]
[indent=1]Using Default Values for Ports[/indent]
[indent=1]Configuring Tracing Level in Transformations[/indent]
[indent=1]Reusable Transformations[/indent]

[b]Aggregator Transformation[/b]
[indent=1]Aggregate Expressions[/indent]
[indent=1]Group By Ports[/indent]
[indent=1]Using Sorted Input[/indent]
[indent=1]Creating an Aggregator Transformation[/indent]

[b]Expression Transformation[/b]
[indent=1]Creating an Expression Transformation[/indent]

[b]Filter Transformation[/b]
[indent=1]Filter Condition[/indent]
[indent=1]Creating a Filter Transformation[/indent]

[b]Joiner Transformation[/b]

[indent=1]Joiner Transformation Properties[/indent]
[indent=1]Defining a Join Condition[/indent]
[indent=1]Defining the Join Type[/indent]
[indent=1]Using Sorted Input[/indent]
[indent=1]Joining Data from a Single Source[/indent]
[indent=1]Blocking the Source Pipelines[/indent]
[indent=1]Working with Transactions[/indent]
[indent=1]Creating a Joiner Transformation[/indent]

[b]Lookup Transformation[/b]

[indent=1]Connected and Unconnected Lookups[/indent]
[indent=1]Relational and Flat File Lookups[/indent]
[indent=1]Lookup Components[/indent]
[indent=1]Lookup Properties[/indent]
[indent=1]Lookup Query[/indent]
[indent=1]Lookup Condition[/indent]
[indent=1]Lookup Caches[/indent]
[indent=1]Configuring Unconnected Lookup Transformations[/indent]
[indent=1]Creating a Lookup Transformation[/indent]

[b]Normalizer Transformation[/b]
[indent=1]Normalizer Transformation Components[/indent]
[indent=1]Normalizer Transformation Generated Keys[/indent]
[indent=1]VSAM Normalizer Transformation[/indent]
[indent=1]Pipeline Normalizer Transformation[/indent]
[indent=1]Using a Normalizer Transformation in a Mapping[/indent]

[b]Rank Transformation[/b]
[indent=1]Ports in a Rank Transformation[/indent]
[indent=1]Defining Groups[/indent]
[indent=1]Creating a Rank Transformation[/indent]

[b]Router Transformation[/b]
[indent=1]Working with Groups[/indent]
[indent=1]Working with Ports[/indent]
[indent=1]Connecting Router Transformations in a Mapping[/indent]
[indent=1]Creating a Router Transformation[/indent]

[b]Sequence Generator Transformation[/b]
[indent=1]Common Uses[/indent]
[indent=1]Sequence Generator Ports[/indent]
[indent=1]Transformation Properties[/indent]
[indent=1]Creating a Sequence Generator Transformation[/indent]

[b]Sorter Transformation[/b]
[indent=1]Sorting Data[/indent]
[indent=1]Sorter Transformation Properties[/indent]
[indent=1]Creating a Sorter Transformation[/indent]

[b]Source Qualifier Transformation[/b]
[indent=1]Source Qualifier Transformation Properties[/indent]
[indent=1]Default Query[/indent]
[indent=1]Joining Source Data[/indent]
[indent=1]Adding an SQL Query[/indent]
[indent=1]Entering a User-Defined Join[/indent]
[indent=1]Outer Join Support[/indent]
[indent=1]Entering a Source Filter[/indent]
[indent=1]Using Sorted Ports[/indent]
[indent=1]Select Distinct[/indent]
[indent=1]Adding Pre- and Post-Session SQL Commands[/indent]
[indent=1]Creating a Source Qualifier Transformation[/indent]

[b]Stored Procedure Transformation[/b]
[indent=1]Connected and Unconnected Transformations[/indent]
[indent=1]Input and Output Data[/indent]
[indent=1]Running a Stored Procedure[/indent]
[indent=1]Using a Stored Procedure in a Mapping[/indent]
[indent=1]Writing a Stored Procedure[/indent]
[indent=1]Creating a Stored Procedure Transformation[/indent]
[indent=1]Configuring a Connected Transformation[/indent]
[indent=1]Configuring an Unconnected Transformation[/indent]
[indent=1]Error Handling[/indent]
[indent=1]Supported Databases[/indent]
[indent=1]Expression Rules[/indent]

[b]Union Transformation[/b]
[indent=1]Working with Groups and Ports[/indent]
[indent=1]Creating a Union Transformation[/indent]
[indent=1]Using a Union Transformation in Mappings[/indent]

[b]Update Strategy Transformation[/b]
[indent=1]Flagging Rows Within a Mapping[/indent]
[indent=1]Setting the Update Strategy for a Session[/indent]
[indent=1]Update Strategy Checklist[/indent]

[b]XML Transformations[/b]
[indent=1]XML Source Qualifier Transformation[/indent]

[b]Overview of Transformations[/b]
SQL Transformation
External Procedure Transformation
Transaction Control Transformation
[indent=1]HTTP Transformation[/indent]


[b][u]MODULE – 4 [/u][/b][u]Informatica Performance Tuning [/u]
Identifying Bottlenecks
Identifying Target Bottlenecks
Identifying Source Bottlenecks
[indent=1]Using a Filter Transformation[/indent]
[indent=1]Using a Read Test Mapping [/indent]
[indent=1]Using a Database Query [/indent]
Identifying Mapping Bottlenecks
Identifying System Bottlenecks

Optimizing the Target
[indent=1]Flat File Target .[/indent]
[indent=1]Relational Target[/indent]
Dropping Indexes and Key Constraints
Increasing Database Checkpoint Intervals
Using Bulk Loads
Using External Loads
Minimizing Deadlocks
Increasing Database Network Packet Size
Optimizing Oracle Target Databases
Optimizing the Source
Optimizing the Query
Using Conditional Filters
Increasing Database Network Packet Size
Connecting to Oracle Database Sources
Chapter 5: Optimizing Mappings
Optimizing Flat File Sources
[indent=1]Optimizing the Line Sequential Buffer Length[/indent]
[indent=1]Optimizing Delimited Flat File Sources[/indent]
Configuring Single-Pass Reading
Optimizing Simple Pass Through Mappings
Optimizing Filters
Optimizing Datatype Conversions
Optimizing Expressions
[indent=1]Factoring Out Common Logic[/indent]
[indent=1]Minimizing Aggregate Function Calls [/indent]
[indent=1]Replacing Common Expressions with Local Variables[/indent]
[indent=1]Choosing Numeric Versus String Operations[/indent]
[indent=1]Optimizing Char-Char and Char-Varchar Comparisons [/indent]
[indent=1]Choosing DECODE Versus LOOKUP[/indent]
[indent=1]Using Operators Instead of Functions[/indent]
[indent=1]Optimizing IIF Expressions[/indent]
[indent=1]Evaluating Expressions [/indent]

[b] Optimizing Transformations [/b]
Optimizing Aggregator Transformations
[indent=1]Group By Simple Columns[/indent]
[indent=1]Use Sorted Input[/indent]
[indent=1]Use Incremental Aggregation [/indent]
[indent=1]Filter Data Before You Aggregate[/indent]
[indent=1]Limit Port Connections [/indent]
Optimizing Custom Transformations
Optimizing Joiner Transformations
Optimizing Lookup Transformations
[indent=1]Using Optimal Database Drivers[/indent]
[indent=1]Caching Lookup Tables [/indent]
[indent=1]Optimizing the Lookup Condition[/indent]
[indent=1]Indexing the Lookup Table[/indent]
[indent=1]Optimizing Multiple Lookups[/indent]
Optimizing Sequence Generator Transformations
Optimizing Sorter Transformations
[indent=1]Allocating Memory [/indent]
[indent=1]Work Directories for Partitions[/indent]
Optimizing Source Qualifier Transformations

[center]*****[/center]